topic Re: How to compare in pivot table?? in QlikView

How to compare in pivot table??

jsingh71 — Tue, 11 Dec 2012 09:12:26 GMT

Hi All,

I want to comapre Q2 with Q1, Q3 with Q2 and Q4 with Q3. and if 'absenteeism' is greater then previous Quarter then represent by UP arraow else represent by Down arrow for showing arrow we have to add one more column.

Please find .qvw file in attachment.

Re: How to compare in pivot table??

fdelacal — Tue, 11 Dec 2012 09:18:10 GMT

can you save the qvw with a reload, any data to see.
Thanks

Re: How to compare in pivot table??

jsingh71 — Tue, 11 Dec 2012 09:29:06 GMT

Now I update the qvw file...

Re: How to compare in pivot table??

fdelacal — Tue, 11 Dec 2012 09:50:04 GMT

I hope it helps you.

see atach qvw.

Regards

Re: How to compare in pivot table??

er_mohit — Mon, 24 Dec 2012 06:38:56 GMT

if in your pivot table having add expression for virtual column u hav made. this and want to see comparision in them

use column () function like

column(2)-column(1)

hope it helps you

Re: How to compare in pivot table??

kaushiknsolanki — Mon, 24 Dec 2012 07:02:25 GMT

Hi,

Have a look at the file attached.

The expression used is

if(Above([Absenteeism %])<=Sum(Absenteeism%),'qmem://<bundled>/BuiltIn/thumb2.png','qmem://<bundled>/BuiltIn/thumb1.png')

Add this expression in your chart.

Hope this will solve your problem.

Regards,

Kaushik Solanki

Re: How to compare in pivot table??

jsingh71 — Mon, 24 Dec 2012 07:46:13 GMT

Thanks Kaushik.....