Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
JoannaM
Contributor II
Contributor II

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 II
Contributor II
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 II
Contributor II
Author

 
sunny_talwar

might be easier to help if you can share a sample

JoannaM
Contributor II
Contributor II
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 II
Contributor II
Author

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

JoannaM
Contributor II
Contributor II
Author

Solved with an expression by breaking down the material groups.

View solution in original post