topic Re: Dimension Background Color not showing correctly unless being selected in QlikView

Dimension Background Color not showing correctly unless being selected

sielareviv7 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Dimension Background Color not showing correctly unless being selected

isingh30 — Tue, 22 May 2018 16:31:54 GMT

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

Thank you!

Re: Dimension Background Color not showing correctly unless being selected

isingh30 — Tue, 22 May 2018 16:32:40 GMT

Can you share sample application?

Re: Dimension Background Color not showing correctly unless being selected

sielareviv7 — Tue, 22 May 2018 16:38:20 GMT

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.

Re: Dimension Background Color not showing correctly unless being selected

shansundar — Tue, 22 May 2018 16:43:01 GMT

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