Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pivot table

         Hi,

            I am a newbie to qlikview .

             I want  cummulatives (Roll ups ) in pivot table  as 2nd example .

I have below pivot table :

          Term                  DaysSinceStart     0-90 days       91-180 days    181-270 days     271-360 days  

          SP  1 2008                                       141                  31                  125                     4

    I want  Roll ups of above   Pivot table in Qlikview  As Below  example :

    Example :  

        Term                DaysSinceStart           0-90   days    0-180 days    0-270 days       0-360 days

        SP  1 2008                                          141               172                 297                 301

  Suggest me expression   or set analysis to approach the result .

   I tried if statement with buckets 0-90 days , 0-180 days  ,0-270 days  & 0-360 days But they are not giving exact number as roll ups should be.

  Suggest me the solution .

     Thanks.