Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Specialist
Partner - Specialist

4 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

could you scramble your dimensions and attach your qvw?

Anonymous
Not applicable
Author

Ho fatto un'esempio, ecco il qvw

bbi_mba_76
Partner - Specialist
Partner - Specialist

Here an example

Anonymous
Not applicable
Author

it works perfectly! best regards