Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qlikview Community,
My problem is that I would like to represent prior year under the dimension of current year. However at the moment using this code:
sum({<[SAP Year]={$(=[SAP Year]-1)}>}[Net Sales Local Currency]*[ER SAP CY])
but getting this result:
2012 | 2013 | |
Sales | 1,915,861 | |
Prior Year | 10,500,564 |
But would like it to look like this:
2013 | |
Sales | 1,915,861 |
Prior Year | 10,500,564 |
Transpose this tale and you would be able to do that. Also Make expressions for both the Sales and Prior Year sales.
-Abhinava
Don't use a dimension, only expressions. See attached example.