Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Pivot Chart Expression

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!

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Pivot Chart Expression

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


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Pivot Chart Expression

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!

Highlighted
MVP & Luminary
MVP & Luminary

Re: Pivot Chart Expression

because I may randomly select the PW

And what result do you expect then?


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Pivot Chart Expression

Dear Gysbert,

Thanks!

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

image1.jpg

Expected Result is

Expected Result.jpg

Looking forward for your reply.

Gowthami

Highlighted
MVP & Luminary
MVP & Luminary

Re: Pivot Chart Expression

Please post a qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand
Highlighted
sasikanth
Valued Contributor III

Re: Pivot Chart Expression

Hi

Try some thing like this,

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