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: 
ringolau
Contributor III
Contributor III

Rangesum question

Hi,

I want to create a straight table with an accumulative sold by RangeSum() at season level. Currently I create an expression

rangesum(above (TOTAL sum([sales qty]),0,rowno())) by the accumulative sales breaks at Year level, I tried to put season desciption in the function like this but with no luck, anything is missing?

rangesum(above (TOTAL sum([sales qty]),0,rowno()), [season description])

sample.jpg

4 Replies
Not applicable

Put the TOTAL also in the Rowno:

Rowno(TOTAL)

ringolau
Contributor III
Contributor III
Author

Thanks Lous,

Let me make it clear, in the straight table, there will be different brand and season. What I want is to have an accumulated sales grouped by season and brand.

Not applicable

I once tried to add a dimension to the TOTAL clause in a Rangesum, this way:

rangesum(above (TOTAL<Brand, Season> sum([sales qty]),0,rowno(TOTAL<Brand, Seaso>)), [season description])

...but it didn´t seem to work. Can't you use a pivot table there? That way yuo can choose to sum the dimensions you want. Thats the way I usually do.

ringolau
Contributor III
Contributor III
Author

sample.jpg

My workaround is to combine [year + month] in one dimension and use this

rangesum( above(sum([sales qty]),0,rowno())

Somehow when the date is in more than one dimension, still don't figure out how to do the grouping nicely.