topic Background Color on Dimension "Bug" ? in QlikView

Background Color on Dimension "Bug" ?

Fri, 22 Jan 2010 15:27:35 GMT

I am trying to highlight the color of a dimension depending on a Flag value, but found that if the value of the first column is null, it failed to work. Want to know whether anyone encountered this problem. Is this a bug, design flag or I am using the method wrongly.

Eg:

Table fields: Date, Flag, Product, Value

Date Dimension-> Background Color = If (Flag=1,RED())

When I added a Total and show it at the first column, the logic works but without Total it does not work, or it will also show if the first value contains value.

Any advise will be appreciated. Am using QV Client Ver 9.00.7320.7 SR2.

Background Color on Dimension "Bug" ?

Thu, 28 Jan 2010 14:41:28 GMT

Hi,

You can solve it.

Press right button in the pivot table, in the tab "Presentation", uncheck "suppress zero values" and it's works well.

Sorry I dont speak english very well.

Background Color on Dimension "Bug" ?

stevedark — Thu, 13 May 2010 22:20:44 GMT

Hi,

I can confirm that 'suppress zero values' works - thanks for the tip.

Regards,
Steve

Background Color on Dimension "Bug" ?

Thu, 01 Jul 2010 09:15:21 GMT

Hi all,

now I found the same problem as limch and I try to do following your suggestion. But It's not work. Despite I uncheck "suppress zero values" ,some filed that has null value still not change the color.

This is my code :

if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL') ,RGB(0,0,204),black())

Could someone tell me how can I solve this problem?

Regards.