Discussion board where members can get started with Qlik Sense.
I have a pivot table in which there are month columns ie. April-March.I want to calculate variance between the two selected months.
Eg. If i select April and March i should be getting the vairance between them in the next column called variance in a pivot table.
Thanks & Regards,
Do you have a sample you can provide with the expected output?
Cant uplaod the data but attaching an image for more clear understanding.
Now i have selected Jan and Feb so i got the variance as shown in image,in short based on selection of two months i sould get the variance.
My dimension is Month and
Expression is Sum(Cost Amount)
I used this formula:
Sum(Amount) - Above(Sum(Amount))
But it only work when data is present in both months, but when i select Jan and Feb
Jan has some value and feb is null den it gives me null only.
How about this:
Not working Sunny, Still getting null values
Use Alt() function
In the expected output i am getting 265 where i should get -265
if you use a pivot table in qlik sense dont use above function but before() :
sum(amount) - before(sum(amount))
hope it helps
Thanks for the reply but it doesnt work