topic setting background color based on value of expression in QlikView

setting background color based on value of expression

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

this is in qlik 12, if it matters. I have a hugely long/complex expression, in a pivot table, labeled A. I want to change the background color of the cell, based on the value of this expression, to red, yellow or green. all i can find, searching here, is how to change color based on the value of a variable or based on the value of a dimension. this is neither. do i really have to put :

if (HUGEEXPRESSION)>-.1, $vgreen

i was hoping i could do something like :

If (A>.1), $vgreen

but that doesn't work. is this possible?

thanks

becki kain

Re: setting background color based on value of expression

jerem1234 — Thu, 03 May 2018 20:14:17 GMT

Hi becki,

If you are trying to edit the background color on the expression tab, then yea you can. The formula would be like:

if (A =16, red())

Please find attached.

Hope this helps!

Re: setting background color based on value of expression

vinod22kv — Fri, 04 May 2018 08:52:40 GMT

Hi,

There is a opection called visual cues in qlikview you can trye that. it is usefull for your requrement.

Regards,

Vinod.

Re: setting background color based on value of expression

becki_kain — Fri, 04 May 2018 15:40:45 GMT

yes thanks

do you have a way to do If A>.2 and A<1 (nested if statements)?

Re: setting background color based on value of expression

jerem1234 — Fri, 04 May 2018 15:44:41 GMT

Yep, something like:

if (A >5 and A <17, red())

Re: setting background color based on value of expression

jerem1234 — Fri, 04 May 2018 15:46:54 GMT

You can also do something like:

if (A >5 and A <17, red(),

if(A>50, rgb (50, 120, 50), rgb(100, 100, 100)))

Re: setting background color based on value of expression

becki_kain — Fri, 04 May 2018 15:53:35 GMT

i was getting caught up in () and where they should go! thanks