topic Re: Pivot Chart Expression in QlikView

Pivot Chart Expression

Fri, 08 May 2015 07:46:39 GMT

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!

Re: Pivot Chart Expression

Gysbert_Wassenaar — Fri, 08 May 2015 08:15:50 GMT

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

Re: Pivot Chart Expression

Fri, 08 May 2015 08:35:08 GMT

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!

Re: Pivot Chart Expression

Gysbert_Wassenaar — Fri, 08 May 2015 08:38:44 GMT

because I may randomly select the PW

And what result do you expect then?

Re: Pivot Chart Expression

Fri, 08 May 2015 09:47:05 GMT

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

Re: Pivot Chart Expression

Gysbert_Wassenaar — Fri, 08 May 2015 10:14:56 GMT

Please post a qlikview document that demonstrates the problem.

Re: Pivot Chart Expression

sasikanth — Fri, 08 May 2015 10:47:39 GMT

Try some thing like this,

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