Discussion board where members can get started with QlikView.
Hi, can anyone please help me to achieve the below:
I have one pivot table like below:
Now I want to create a additional calculated row in the above table to find difference of each month between the programs (first column) as below
like above I want to create calculated row P81 o/u P82 (P81->Australia->Ca - P82->Australia->Ca) for all the months.
There is a solution. Please, see at this short instace:
First of all you need to load additional table in the script
After that, write your calculated dimension like this:
And expression like this:
This way will calculate sum for P* rows for dim = 1 and difference of P* rows for dim = 2.
View solution in original post
Thank you so much.