Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
can you save the qvw with a reload, any data to see.
Thanks
Now I update the qvw file...
I hope it helps you.
see atach qvw.
Regards
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
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
Thanks Kaushik.....