Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
salim
Partner - Contributor
Partner - Contributor

rangesum with 2 dimensions

Hi,

I need your help because I have to plot a graph with two dimensions and accumulate data on time but with the following formula data are not cumulative.

At the beginning I used this formula with the rangesum above but without success

rangesum(above(count(distinct projet),0,rowno()))

After I added an aggr according to the 2 dimensions (status and date) but it still does not work

aggr(rangesum(above(count(distinct projet),0,rowno())),statut,date)

 

Please can you help me ? 

 

Thanks

Labels (2)
1 Reply
MayilVahanan

Hi 

Hope below link will help

https://community.qlik.com/t5/New-to-Qlik-Sense/Cummulative-SUM-with-2-dimensions/td-p/1620571

https://community.qlik.com/t5/New-to-Qlik-Sense/Cumulative-with-two-dimension/td-p/1511448

 

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.