Rangesum by dimension

kirsten_dc — Sat, 16 Nov 2024 02:10:34 GMT

Hi all,

I have some problems with the following table:

I have the two dimensions 'WeekNumber' and 'Branch' and some expressions.
In my last expression I want to show the cumulated sales per 'Branch' until this 'WeekNumber'.

I used this formula:

RangeSum(Above(total Sum({$<gYear={$(=Max(gYear))}>}fvGrossSales) , 0, gWeek))

As you can see, it cumulates everything without regarding for the branches. I already tried using aggr() but I do not get the right solution.

Any advices?

Regards
Kirsten

Re: Rangesum by dimension

Brett_Bleess — Wed, 30 Oct 2019 15:34:24 GMT

Kirsten, I am afraid I am not a Set Analysis guru myself, so the best I have is a Design Blog post that has some info and some additional posts related to different features of Set Analysis, so hopefully they may help you figure it out:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

My post will also kick things back up in the list too, so someone else that is better at this may see things and have some direct ideas on where things are going wrong too. Sorry I am not more help to you on this one.

Regards,
Brett

topic Rangesum by dimension in QlikView

Rangesum by dimension

Re: Rangesum by dimension