topic Re: Visual prompts in QlikView

Visual prompts

Wed, 01 Jun 2016 12:50:36 GMT

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!

Re: Visual prompts

Aurelien_Martinez — Wed, 01 Jun 2016 13:25:40 GMT

Hi Alexander,

See my qvw.

Aurélien

Re: Visual prompts

Peter_Cammaert — Wed, 01 Jun 2016 13:47:43 GMT

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

Re: Visual prompts

Anonymous — Wed, 01 Jun 2016 14:56:40 GMT

Hi Peter,

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

Regards,

Re: Visual prompts

Peter_Cammaert — Wed, 01 Jun 2016 17:34:31 GMT

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.