Visual prompts

[#1]

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!

[Aurelien_Martinez · Accepted solution]

Hi Alexander,

See my qvw.

Aurélien

[Peter_Cammaert]

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

[Anonymous]

Hi Peter,

On straight and pivot table you have an option on properties to do this, on tab Visual Cues.

Regards,

[Peter_Cammaert]

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.