Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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