5 Replies Latest reply: Mar 2, 2012 11:08 AM by Derek Jones RSS

Conditional Format on Totals is incorrect when export to Excel

Derek Jones

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