topic Re: Rangesum question in QlikView

Rangesum question

ringolau — Wed, 14 Aug 2013 09:51:11 GMT

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])

Re: Rangesum question

Wed, 14 Aug 2013 09:56:26 GMT

Put the TOTAL also in the Rowno:

Rowno(TOTAL)

Re: Rangesum question

ringolau — Wed, 14 Aug 2013 10:01:58 GMT

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.

Re: Rangesum question

Wed, 14 Aug 2013 10:14:35 GMT

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.

Re: Rangesum question

ringolau — Thu, 15 Aug 2013 06:04:33 GMT

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.