Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Rangesum cumulative sum partially working

Solved with an expression by breaking down the material groups.

7 Replies

Re: Rangesum cumulative sum partially working

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

Re: Rangesum cumulative sum partially working

 

Re: Rangesum cumulative sum partially working

might be easier to help if you can share a sample

JoannaM
New Contributor II

Re: Rangesum cumulative sum partially working

What kind of sample would help?

Re: Rangesum cumulative sum partially working

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

JoannaM
New Contributor II

Re: Rangesum cumulative sum partially working

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

JoannaM
New Contributor II

Re: Rangesum cumulative sum partially working

Solved with an expression by breaking down the material groups.