Dimension Background Color not showing correctly unless being selected

[sielareviv7]

Hi All

I am new to Qlikview so even though I scrolled through all the existing questions and tried all different expressions, the background color is still not showing correctly.

Since WOC is already ranked from smallest to largest, I want to show color red on the top, then yellow, then green based on the number. Logic is WOC = Inventory/Demand

Inventory =Aggr(sum(On_Hand+In_Transit),SKU)

Demand=Aggr(sum(num(Demand,'#,##0')),SKU)

WOC=NUM(Aggr(sum(On_Hand+In_Transit),SKU)/Aggr(sum(Demand),SKU),'#,##0')

and background color expression for WOC =

=If(NUM(Aggr(sum(On_Hand+In_Transit),SKU)/Aggr(sum(Demand),SKU),'#,##0')>=8,RGB(0,255,0),

If(NUMAggr(sum(On_Hand+In_Transit),SKU)/Aggr(sum(Demand),SKU),'#,##0')>=4,Yellow(),

RGB(255,0,0)))

The background color is showing like below, however if I select one of the SKU the color adjusts ( Red 8 will become yellow for example)

Thank you all for your help! Any suggestions or comments are greatly appreciated!

[isingh30]

If the color is based on number then you can do this in visual cues tab. What chart you are using?

Thank you!

[isingh30]

Can you share sample application?

[sielareviv7]

I am doing a pivot table, and since all three fields are dimensions I am not sure if there's anyway to add dimension to visual cues tab.

[shansundar]

Your expression in correct just you have to include additional brackets for the division before comparing it with a value, but its always advisable to use the expression label reference for these kind of scenario's.

In the background color expression, you can say like,

=If([WOC] >=8, RGB(0,255,0),

  If([WOC] >=4,Yellow(), RGB(255,0,0)

  )

  )

Thanks,

Shan S