topic Visual cue query in QlikView

Visual cue query

Fri, 17 Feb 2012 15:56:12 GMT

Greetings all,

I have a chart where I wish to display conditional formatting based on another % field but with three options:

If the total displayed in this field is greater than...sum({<Link_Date = {'40853'} >} SATS)/100.....display green

If it equals the same....display amber

If less than...display red

I normally use the Expression text colour for true/false but this obviously has a third option.

I have tried using the Visual cues and variations on the following

>= (sum({<Link_Date = {'40853'} >} SATS)/100)+1...

normal: sum({<Link_Date = {'40853'} >} SATS)/100...

<= (sum({<Link_Date = {'40853'} >} SATS)/100)-1....

This is probably an easy fix but I cannot see it at the moment...

Thanks for any help

Fri, 17 Feb 2012 17:17:22 GMT

Any ideas anyone?

In the meantime, I have used an Text Colour Expression

if(sum({< Link_Date = {'40944'} >}SATS)>sum({< Link_Date = {'40853'} >}SATS),lightgreen(),lightred())

but this will obviously highlight red where the total is the same on both days and I would like amber.

Is it possible to have more than 1 true/false statement on a Text Colour Expression?

deepakk — Fri, 17 Feb 2012 17:22:26 GMT

Yes. Its possible.

Try thos out.

if(sum({< Link_Date = {'40944'} >}SATS)>sum({< Link_Date = {'40853'} >}SATS),lightgreen(),

If(sum({< Link_Date = {'40944'} >}SATS) =sum({< Link_Date = {'40853'} >}SATS), amber(),

lightred()))

Deepak

Fri, 17 Feb 2012 17:24:52 GMT

Yes, that is a great help Deepak, thank you.