Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

RangeSum on line chart with 2 dimensions

Hello
got a line chart with 1 dimension called Category
I got a simply expression sum(man_days)
I want the cumulative sum so I used the rangesum(above(sum(man_days),0,rowno())) and it works fine
Now I added a new dimension called Division and I want to calculate the cumulative % of mandays per each division by category

the expression is now rangesum(above(sum(man_days)/sum(total<Division>man_days),1,rowno())) 
the above expression doesn't work ( i mean no accumulation is made) checked rangesum(above(sum(man_days)/sum(total<Division>man_days),1,rowno())) it gives zero

I then tried aggr(rangesum(above(sum(man_days)/sum(total<Division>man_days),1,rowno())) ,CAtegory, Divsion) but didn't work

Kindly advise

I can walk on water when it freezes
Labels (1)
2 Replies
Aasir
Creator III
Creator III

RangeSum(Above(Sum(man_days) / Sum(Total <Division> man_days), 0, RowNo(Total <Category, Division>)))

ali_hijazi
Partner - Master II
Partner - Master II
Author

rowno() doesn't take other than Total as parameter

please if you are not sure of the answer, don't post it

I can walk on water when it freezes