Discussion board where members can get started with QlikView.
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 :
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 .