Hoe to rollup data by selection

Mon, 27 May 2013 07:55:13 GMT

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.

Re: Hoe to rollup data by selection

kumarnatarajan — Mon, 27 May 2013 08:21:44 GMT

Hi,

try this one.

Ex: SUM({$<Month={"<= $(=MAX(Month))"}>} Amount)

topic Re: Hoe to rollup data by selection in QlikView

Hoe to rollup data by selection

Re: Hoe to rollup data by selection