Discussion Board for collaboration related to QlikView App Development.
I have below data, which i am trying to project it in Pivot table but not able to display process name having no values in particular week.
How can we achieve this ?
Expected Output in Pivot
Why is P5 = 0?
P5 doesn't have value in week1 but still need to show all the Process irrespective of data availibility
One way of working it out is that add 1 as an additional expression and then hide that column
Pivot Column Width to Zero
Thanks for your reply. I tried this with Macro but when we export the data hidden column will appear.
Do we have any other way to do this ?