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: 
derekjones
Creator III
Creator III

Conditional Format on Totals is incorrect when export to Excel

Hi All

I'm wondering if this is a bug or if I'm missing a trick....

I have a straight table with a daily target and a day by day sales. To conditionally format green if they hit their daily and red if they haven't, in the expression I've put an if statement for the background colour and text e.g.

=if([Target]-[Day1]>0,RGB(255,0,0),RGB(0,255,0))

Now, in Qlikview itself it all behaves as I expect, if you see in my qvw attached, the totals at the bottom are £7500 target for each day and Day 1 achieves only £7460, so is red, Day 2 is £4900 so is red and Day 3 is £8000 so is green.

formattest.bmp

However, whenever I send to excel, the formatting is wrong on the totals i.e. Day 1 is green when it should be red?

formattestxl.bmp

If this is a bug, how does one report it?

My thanks in advance for any assistance

Derek

5 Replies
Not applicable

He Derek,

When I export the table to Excel, I get the same format as in qlikview.

It works fine at my computer.

Which Qlikview version are you using and which version of Excel?

gr.

Frank

oxtontom
Contributor III
Contributor III

Hey Derek,

I get the same issues with the formatting as you I am using QV10 and office 2007.

Tom

Anonymous
Not applicable

Hi

     I am getting the same issue to fix this i delete that expression and created once again the same expression in the chart.

     Then its working file

Regards

Ashok

derekjones
Creator III
Creator III
Author

Hi frankcrezee

That's intersting, I have QV 10 SR3 and Excel 2010.

Kind regards

Derek

derekjones
Creator III
Creator III
Author

Hi Ashok

How exactly are you recreating the expression? If I delete it then recreate it exactly as it is, it still fails?

Thanks

Derek