Customize Pivot table or Chart

qlikview

#1

Hi
i having a strange requirement and a challenging one
where as i am having a data of
sample data as below any help is would be appreciated
Emp name product avg market value per
product in days

avg over all
engineers data with product here
% were calculated by col(2) by col(1)

venkat wipro
7.5
2.5
2.5/7.5 = some value in

sunil airtel
8.5
5

arun idea
6
9.5

satish airtel
8.5
8

rani
wipro
7.5
10

my problem is here i am freezing the values by using sum(total{<empname=, Product= > closures) and same for the product

where has when i make a selections on empName =Rani or any at the the bottom only her values should be visible
but here i am getting the data this way

Emp name product avg market value per
product in days

avg over all
engineers data with product here
% were calculated by col(2) by col(1)

venkat wipro – -- -

sunil airtel -

arun idea - - -

satish airtel — -

rani wipro 7.5 10 7.5/10 = 1.33

ok that’s my problem where has its should be only visible or it should be populate to the top as we see in the list box
here in sample data i have only 4 rows but in my app around thousand of record were there i cant scroll down to see where this values were there

Help: it should behave a like list box selections for example what ever value i select it should populate at top or
should come like a normal straight table


#2

sorry tabular format came wrong over there
you can see in pic my issue and the data sample


#3

@venkatrao,

You can solve this issues in two ways:

  • Suppress the zero or missing values on presentation tab the it will automatically show the observation having some values.
  • Use Sort option and select Sort By - Y value.

Hope this work for you!

Regards,
Imran


#4

HI Imran in Pivot table we dont have Y value sorting where it is available in charts like (bar, line )

here i am having the issue not about the null values

the selected value should be popped up to first place ie.,

instead of standing at potion 5, it should pop to first

and one more in the column of avg over all
engineers data with product here
it is static we are freezing stating excluding the selections