Conditional Format on Totals is incorrect when export to Excel

[derekjones]

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.

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

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

My thanks in advance for any assistance

Derek

[#2]

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]

Hey Derek,

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

Tom

[Anonymous]

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]

Hi frankcrezee

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

Kind regards

Derek

[derekjones]

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