Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lord_zeus
Partner - Contributor III
Partner - Contributor III

Cumulative total for relative value

Hello, everybody!

Im try to calculate a relative value for chart visualisation where dimantion in days spend (0,1,2 etc)

Problem: in component of formula i need a cumulative total by my dimantion. 

I'm make some example:

2020-01-22 19_21_31-Книга1 - Excel.png

Im wont get chart like this

2020-01-22 19_29_39-Книга1 - Excel.png

the problem is that I cannot use the previous values ​​for the calculation. I need to take a measurement and count less than the current in a variable or in SetAnalysis

Labels (3)
1 Solution

Accepted Solutions
Kushal_Chawda

may be this

=(rangesum(above(total sum({<ID>}OUT),0,RowNo(total)))/rangesum(above(total sum({<ID>}IN),0,RowNo(total))))*avg(1)

 

 Where ID is the X-axis Dimension

View solution in original post

2 Replies
Kushal_Chawda

may be this

=(rangesum(above(total sum({<ID>}OUT),0,RowNo(total)))/rangesum(above(total sum({<ID>}IN),0,RowNo(total))))*avg(1)

 

 Where ID is the X-axis Dimension

lord_zeus
Partner - Contributor III
Partner - Contributor III
Author

Thenks, its work.

Im make a reference table and add it to model with references to main table. Im need it becose my formula with count(distinct id) ... so im need to calculate unicu id in each row...