6 Replies Latest reply: Dec 1, 2016 11:29 AM by John Schmidt

# Qlik Sense - Dynamic coloring

Hi,

i'm making my first steps with Qlik Sense and i'm having trouble with dynamic coloring of my bar chart.

I have a dummy bar chart with one dimension (ACTION) and two integer values '(THIS_WEEK)' and '(THIS_WEEK) - (LAST_WEEK)'.

The last value is calculated as a formular as can be seen above.

What i want to do:

Value '(THIS_WEEK)' is supposed to have a fixed color value.

The formular value is supposed to be red when < 0 and green when > 0.

I cant really believe that setting specific dynamic color values cant be done using the gui but well ...

I have red some other threads here and i cant really get it to work. My color formular is always being applied to both values but i would like

to apply one for one value and one for the other value.

Can somebody help me with this?

• ###### Re: Qlik Sense - Dynamic coloring

Maybe you should look at the valuelist() function.

For example (for you to understand how it works)

Put in dimension :

valuelist('FirstValue','SecondValue')

Put in Expression:

if(valuelist('FirstValue','SecondValue')='FirstValue', 10000,2000)

put in color expression:

if(valuelist('FirstValue','SecondValue')='FirstValue', red(),green())

• ###### Re: Qlik Sense - Dynamic coloring

Hi,

I'm afraid i still dont get the logic behind it.

I still dont see how this helps me when trying to apply the colors to my two measures separately.

How exatcly to i adress my 2 measures to appply the color?

• ###### Re: Qlik Sense - Dynamic coloring

This case allows you to create an only one measure, separated by the dimension value that you created out of the model. So you can apply different colors to the different dimensions (so the different expressions).

Did you try it ?

• ###### Re: Qlik Sense - Dynamic coloring

No, because i dont understand it im afraid.

Im in the formular textarea of my bar chart in the tab fpr colors and legend.

How exatcly would by formular look like to achieve my color logic when i have two measure like this:

- sum([THIS_WEEK])

- sum([THIS_WEEK]) - sum([LAST_WEEK])

• ###### Re: Qlik Sense - Dynamic coloring

So, in dimensions (so 2 dimensions)

1 : ACTION

2 : valuelist('Week','DiffWeek')

In measure (only one)

if(valuelist('Week','DiffWeek')='Week',sum([THIS_WEEK]),sum([THIS_WEEK]) - sum([LAST_WEEK]))

In color expression

if(valuelist('Week','DiffWeek')='Week',YOUCOLOR1,YOURCOLOR2)

• ###### Re: Qlik Sense - Dynamic coloring

Ok i got it to work now having differnt colors for my two measures.

Im a bit shocked though what is needed to achieve this - i need to adjust my dimension and measure setup just to

apply dynamic colors?

I really hope this is not the only way but thanks a lot so far.

It solved my problem but i really hope there is an easier way ...

Thanks anyhow!