topic Re: Problem with rolling months on total in QlikView

Problem with rolling months on total

Thu, 21 May 2015 10:33:48 GMT

Hi all,

I need to calculate a market share for a group of products for each month and I'm using a formula like this:

=Sum({<year=,PeriodDate={">=$(=AddMonths(Max(PeriodDate),-12)) <=$(=Max(PeriodDate))"}>} CValue)

Sum( total <PeriodDate> CValue)

I have two dimensions, PeriodDate + the group of products, that's why I need the the total part.

The problem is on the underlined part: I'd need it to have the total for each month but it keeps showing me the total only for the last month.

Do you guys have any suggestion? That would be much appreciated.

Thanks for your help,

Lucia

cesaraccardi — Thu, 21 May 2015 15:48:50 GMT

Hi Lucia,

What if you copy the set analysis expression to the total calculation:

=Sum({<year=,PeriodDate={">=$(=AddMonths(Max(PeriodDate),-12)) <=$(=Max(PeriodDate))"}>} CValue)

Sum( total <PeriodDate> {<year=,PeriodDate={">=$(=AddMonths(Max(PeriodDate),-12)) <=$(=Max(PeriodDate))"}>}CValue)

ramoncova06 — Thu, 21 May 2015 15:57:39 GMT

The total qualifier only gives you the selected month, could your issue be related to that ?

the following post give more details into using total The Aggregation Scope

Thu, 21 May 2015 17:00:31 GMT

Thank you Cesar,

this was exactly the problem!