Discussion board where members can get started with QlikView.
I have this example of data:
Table:Load * inline[Month,Quarter,Data1,Q1,1111,Q3,112,Q2,21232,Q3,213,Q3,3228,Q8,339,Q9,10,Q10,];
I want a pivot table as in the attached file showing all dimension values including those where Data is null.
Besides I want the table to be filter sensitive, so the solution of including a Dual+Dummy field in the expression is not feasible.
Please find this example attached.
Thanks a lot in advance.
View solution in original post