Customize Pivot table or Chart

kanve_03 — Thu, 14 May 2015 12:46:26 GMT

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<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	-		-
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 Resource Library‌

gwassenaar‌sana.ismail‌swuehl‌jagan‌QlikView‌Layout & Visualizations‌App Development‌SETANALYSIS on formula based on variable

Re: Customize Pivot table or Chart

Thu, 14 May 2015 15:04:15 GMT

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?

topic Customize Pivot table or Chart in QlikView

Customize Pivot table or Chart

Re: Customize Pivot table or Chart