Pivot Chart Expression

[#1]

Dear All,

I have a Pivot chart and I need to find a difference calculation.Please help me out.

Please find the attached Excel for more information.

Thanks in advance!

[Gysbert_Wassenaar]

Something like if(below(Quantity)<>0,Quantity-below(Quantity),0)

[#3]

Hi Gysbert,

Thanks for your reply.I tried the expression as you mentioned.But it's not working for all the cases, because I may randomly select the PW(say sometimes I can select 3 or 4 or 5 and so on).In those scenario it's not working.

Looking forward for your reply!

[Gysbert_Wassenaar]

because I may randomly select the PW

And what result do you expect then?

[#5]

Dear Gysbert,

Thanks!

When I am applying the  the Expression given by you,I am getting the following result.

Expected Result is

Looking forward for your reply.

Gowthami

[Gysbert_Wassenaar]

Please post a qlikview document that demonstrates the problem.

[sasikanth]

Hi

Try some thing like this,

if(bottom(Quantity,1)<>0,Quantity-bottom(Quantity,1),0)