Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to get a table like below in the Qlikview , for this I have used expression like this RangeSum(above(Column(2)*column(3),1,aggr(Count(DISTINCT Dimention),Dimention_Group), however I didn't get the desired result, ca any one help me on this.
Column1 | Column2 | Column3 |
---|---|---|
column(2)*column(3)=6 | 2 | 3 |
column(2)*column(3)=20 | 4 | 5 |
column(2)*column(3)=42 | 6 | 7 |
Sum(above three rows)=68 | 12 | 15 |
column(2)*column(3)=15 | 3 | 5 |
column(2)*column(3)=24 | 4 | 6 |
Sum(above 2 rows)=39 | 7 | 11 |
column(2)*column(3) | ||
column(2)*column(3) | ||
column(2)*column(3) | ||
Sum(above 3 rows) |
Regards
John
Got It. I have used only expression as Columan(2)*column(3) it has worked Perfectly.
In pivot table you can achieve this . Go to Presentation tab of Pivot table and check the Partial sum option for desired dimension
See the attached.
This is what you are looking for?
Thanks Kush141087 , Your Application is working fine, however my requirement was different, what I need, the same output that you are getting in the demo app in Pivot, I am expecting it in the Straight table, why because I don't want to show the Group details.
Best Regards
John
Got It. I have used only expression as Columan(2)*column(3) it has worked Perfectly.