Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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.