Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI everybody!
I began working with QV not long ago and have a question, is it possible to fix the visual prompts in the table with the following condition:
red colour if V<30 and W>0.8 simultaneously
So I need to create something like this:
Thanks in advance for any ideas!
Hi Alexander,
See my qvw.
Aurélien
Hi Alexander,
See my qvw.
Aurélien
Assuming that V & W are expression labels, expand the expression tree for V and W in succession and add the following to the Text Color expression field for each one of them:
=IF ((V < 30) and (W > 0.8), Red())
In QlikView you can refer to expression results by way of their label.
Best,
Peter
Hi Peter,
On straight and pivot table you have an option on properties to do this, on tab Visual Cues.
Regards,
Yes, that's true. But in this case you have two dependent expression columns. And in Visual Cues you can only compare one expression to one (calculated) value at a time.