Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jsingh71
Partner
Partner

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
Luminary Alumni
Luminary Alumni

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

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
Partner
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
Luminary Alumni
Luminary Alumni

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

jsingh71
Partner
Partner
Author

Thanks Kaushik.....