Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

0 Replies