Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Customize Pivot table or Chart

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          wipro7.52.52.5/7.5 = some value in
sunil           airtel8.55
arunidea69.5
satishairtel8.58
raniwipro7.510

my problem is here i am freezing the values by using sum(total<Product Team>{<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--
arunidea---
satishairtel-----
raniwipro7.5107.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 Resource Library

gwassenaarsana.ismailswuehljaganQlikViewLayout &amp; VisualizationsApp DevelopmentSETANALYSIS on formula based on variable    

1 Reply
Highlighted
Not applicable

Re: Customize Pivot table or Chart

Hi! Under chart properties>presentation tab> is suppress zero values checked?

Also in expression if you want to be able to make selections in empname field why is it being ignored?:

sum(total<Product Team>{<empname=, Product= > closures)



Please could you provide an example file?