1 Reply Latest reply: May 27, 2013 4:21 AM by Kumar Natarajan RSS

    Hoe to rollup data by selection

    Homprakash Gowda

      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.