Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
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!!
Go to Solution.
Here an example
could you scramble your dimensions and attach your qvw?
Ho fatto un'esempio, ecco il qvw
it works perfectly! best regards