Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jsingh71
Valued Contributor

How to compare in pivot table??

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.

1 Solution

Accepted Solutions

Re: How to compare in pivot table??

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

6 Replies
fdelacal
Valued Contributor

Re: How to compare in pivot table??

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

jsingh71
Valued Contributor

Re: How to compare in pivot table??

Now I update the qvw file...

fdelacal
Valued Contributor

Re: How to compare in pivot table??

I hope it helps you.

see atach qvw.

Regards

er_mohit
Honored Contributor II

Re: How to compare in pivot table??

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??

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

jsingh71
Valued Contributor

Re: How to compare in pivot table??

Thanks Kaushik.....