Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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".
Can anyone help please?
Thanks
Gordon
May be as below: