Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jsingh71
Partner - Specialist
Partner - Specialist

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

6 Replies
fdelacal
Specialist
Specialist

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

jsingh71
Partner - Specialist
Partner - Specialist
Author

Now I update the qvw file...

fdelacal
Specialist
Specialist

I hope it helps you.

see atach qvw.

Regards

er_mohit
Master II
Master II

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jsingh71
Partner - Specialist
Partner - Specialist
Author

Thanks Kaushik.....