0 Replies Latest reply: Jun 15, 2011 10:23 PM by 4krishna RSS

    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.