Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

vmsistemi
New Contributor III

Progressive aggregate sum month by month

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!!

1 Solution

Accepted Solutions
bbi_mba_76
Valued Contributor

Re: Re: Re: Progressive aggregate sum month by month

Here an example

4 Replies
bbi_mba_76
Valued Contributor

Re: Progressive aggregate sum month by month

Hi,

could you scramble your dimensions and attach your qvw?

vmsistemi
New Contributor III

Re: Re: Progressive aggregate sum month by month

Ho fatto un'esempio, ecco il qvw

bbi_mba_76
Valued Contributor

Re: Re: Re: Progressive aggregate sum month by month

Here an example

vmsistemi
New Contributor III

Re: Re: Progressive aggregate sum month by month

it works perfectly! best regards

Community Browser