topic Re: How to format the text with multiple conditions. in QlikView

How to format the text with multiple conditions.

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

I have an expression in a straight table having the values like 0%,10,%,20% upto 240%.

I have to show 90 to 120% values are in Red color and other than this are in Green color.

Visual cues is only supporting two conditions, but how to give multiple conditions in expression attribute.

Can any one help me.

Thanks,Ravi

Re: How to format the text with multiple conditions.

bertinabel — Thu, 22 Dec 2016 00:13:12 GMT

Que tal, Ravi.

Ya intentaste desde las propiedades de la expresion en la opcion color de Texto, y ahi colocar la condicion con un IF, como a continuación te muestro en la imagen:

Saludos.

Re: How to format the text with multiple conditions.

Qrishna — Thu, 22 Dec 2016 00:26:10 GMT

Something like in below pic?

If so PSA

Re: How to format the text with multiple conditions.

varshavig12 — Thu, 22 Dec 2016 03:20:36 GMT

Properties--> Dimension --> Expression --> Text Color

If ( Your_exp > 90 or Your_exp <120 , red(), green())

Re: How to format the text with multiple conditions.

punitpopli — Thu, 22 Dec 2016 03:32:14 GMT

you can use colormix() as well.

Expand the expression
Select text color
expand expression window (i.e. "...")
Select colormix wizard from file menu
Enter the expression you want to evaluate (dont user "=" sign)
Click next
uncheck Auto Normalize and enter number/expression for upper and lower limit
click next and finish, colormix expression will get generated
validate the color coding in you expression

Hope this helps

Re: How to format the text with multiple conditions.

Anonymous — Wed, 28 Dec 2016 16:51:08 GMT

Thanks Its working

Re: How to format the text with multiple conditions.

Anonymous — Wed, 28 Dec 2016 17:03:46 GMT

Thanks for the help, it s working with the above expressions.

Re: How to format the text with multiple conditions.

punitpopli — Thu, 29 Dec 2016 02:31:33 GMT

Hi,

Please mark the reply in above as helpful/correct answer to close the thread