topic Re: Re: Progressive aggregate sum month by month in QlikView

Progressive aggregate sum month by month

Anonymous — Thu, 05 Jun 2014 09:45:13 GMT

Hi all !

I've a problem in a pivot report, wich shows sales values, with 3 dimensions, ordered by month (4th dimension).

I've to calculate sum of sales for current year and previous year, and the percentage variation.

the expression for CURRENT YEAR is:

aggr(rangesum(top(sum({<Year={$(varCurrentYear)}>}

sales), 1, RowNo())), CLI_DES,CLI_AGE_DES, Year, Month)

I need to understand why there are null values in the month with no records.

I need to calculate the progressive values, for example, for CLIENTE: 3A, Month: giu = 85.992

I kindly ask for your help!!

bbi_mba_76 — Thu, 05 Jun 2014 09:52:17 GMT

Hi,

could you scramble your dimensions and attach your qvw?

Anonymous — Thu, 05 Jun 2014 10:21:53 GMT

Ho fatto un'esempio, ecco il qvw

bbi_mba_76 — Thu, 05 Jun 2014 10:53:14 GMT

Here an example

Anonymous — Thu, 05 Jun 2014 12:59:27 GMT

it works perfectly! best regards