Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Hoe to rollup data by selection

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.

1 Reply
kumarnatarajan
Valued Contributor

Re: Hoe to rollup data by selection

Hi,

try this one.

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

Community Browser