How to force pivot tables to show null data as "GAP"
Hi
I am trying to build a pivot table in Qlikview to provide GAP analysis.
I have managed to build the pivot table to show the following information:
Customer
Bags
Boxes
Hangers
Mail sacks
Customer 1
£500,000
GAP
£500,000
£500,000
Customer 2
GAP
£500,000
GAP
£500,000
Customer 3
£100,000
GAP
£500,000
£500,000
Customer 4
£20,000
GAP
GAP
GAP
Customer 5
£8,000
GAP
£250,000
GAP
The problem I now have is if I filter to show just bags (by clicking on Bags) it hides customer 2. I still want to see customer 2 with the "GAP".
Likewise, if I filter by customer 4 it only shows bags, it doesn't show boxes etc with "GAP".
The expression formula being used is " = sum(sales.sales)" and I have then got the table to present "GAP" by ticking the presentation options suppress zero values & suppress missing an use the symbol "GAP".
