Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a problem described as follows:
a PivotTable I have 3 dimensions: country, year and month
and tow expressions: sum (field1) and sum (field2)
I want to get the following result
result( Dec) = sum(field1) Dec) / ( sum(field2 dec) + sum(field2 Nov) + sum (field2 Oct ) )
pour December 2012 :
result= 3185550 / ( 16158 + 17879 + 20188 ) = 58.74
pour November 2012 :
result= 3063960/ ( 17879+ 20188+ 16637) = 56
see attached file
If any one can help
I am available for any questions
Go to Solution.
Hello . Take This.
i still have a problem
the final result for january and february is null
any idea ?
Becuse you don't have the record from previous data
result( FEB11) = sum(field1) feb11) / ( sum(field2 feb11) + sum(field2 gen11) + sum (field2 dic2010 ) )
You don' t have dic2010
do you understand?
For your example :
the data of december 2010 exists
the problem is for all the months of January and February
the "above" function do not get the data from the previous period