Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JoannaM
Contributor III
Contributor III

Rangesum cumulative sum partially working

Hi all,

Second try:

When i filter for one product the data is correct per day (following picture):

per month, per day

clipboard_image_2.png

 

When there's no filter applied, then the whole budget is on one material group:

clipboard_image_3.png

 

Output wanted:

clipboard_image_4.png

Expression:

num(
aggr(rangesum(above(
Sum(total[BU production days])/
sum(total[production days]) *
sum({<year={$(=year(today()))},date={"<$(=makedate(year(Today()), month(Today()), day(Today())))"}>}[production days])
,0,rowno())),year,month,day)
,'#’##0', '.', '’')

What am I missing?

 

1 Solution

Accepted Solutions
JoannaM
Contributor III
Contributor III
Author

Solved with an expression by breaking down the material groups.

View solution in original post

7 Replies
sunny_talwar

Would you be able to add an expression for daily budget (which would be non cumulative)? to see what are the values which are getting used for the accumulation here?

JoannaM
Contributor III
Contributor III
Author

 
sunny_talwar

might be easier to help if you can share a sample

JoannaM
Contributor III
Contributor III
Author

What kind of sample would help?

sunny_talwar

.qvf file if possible or some raw data with the output expected from it

JoannaM
Contributor III
Contributor III
Author

Hi Sunny, I changed my question to make it better understandable.

JoannaM
Contributor III
Contributor III
Author

Solved with an expression by breaking down the material groups.