Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 12 months (Jan to Dec) of data in a fact table. Now consider January as 1, February as 2, March as 3.......December as 12.
Now I want to show data in such way that if I select '1' I want to show January data, If I select '2' then I need to show sum of data January and February, If I select '3' then I need to show sum of January, February and March data..........If I select '12' then I need to sum 12 months of data from January to December.
Please let me know how to achieve this in qlikview.
Thanks,
Om.
Hi,
try this one.
Ex: SUM({$<Month={"<= $(=MAX(Month))"}>} Amount)