Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
Hi,
There is a opection called visual cues in qlikview you can trye that. it is usefull for your requrement.
Regards,
Vinod.
yes thanks
do you have a way to do If A>.2 and A<1 (nested if statements)?
Yep, something like:
if (A >5 and A <17, red())
You can also do something like:
if (A >5 and A <17, red(),
if(A>50, rgb (50, 120, 50), rgb(100, 100, 100)))
i was getting caught up in () and where they should go! thanks