Discussion Board for collaboration on QlikView Layout & Visualizations.
Build a pivot table samething like below
Month Month1 Month2 Total
A 10 20 30
B 20 30 50
C 30 40 70
is when i have no selection on filter "dimension".
and shows respective A, B, C values when a value is selected in filter.
Here when no filter is selected,
I want My table look like
ALL 60 90 160
Go to Solution.
May be use a calculated dimension like this
If(GetSelectedCount(Dimension) = 0, 'ALL', Dimension)