topic Visual Cues based off expression in QlikView

Visual Cues based off expression

Wed, 18 Nov 2015 16:56:55 GMT

Hello,

I am using the following expression to return a percentage

=num(Count({<Method={'1'},UtilizationMonthName={'Month0'}>} Distinct Key) /count({<methddesc={'1','2', '3'},UtilizationMonthName={'Month0'} >} distinct Key),'#,##0%')

what I am trying to do is set a visual cue if the percentages are above and below a set percentage, but I am unsure how to go about this. Any help would be great.

Thanks,

Re: Visual Cues based off expression

Mark_Little — Wed, 18 Nov 2015 17:02:10 GMT

Hi,

you need to be looking at the visual cue tab.

You need to add the upper and lower limit. One thing you may need to check is if you need to use the base number, i.e. pre your num() formating.

If it is just a text box, then you can go to colour and use a expression

If(num(Count({<Method={'1'},UtilizationMonthName={'Month0'}>} Distinct Key) /count({<methddesc={'1','2', '3'},UtilizationMonthName={'Month0'} >} distinct Key),'#,##0%') > 80, Green(), Red())

Or replace with RGB() codes.

Mark

Re: Visual Cues based off expression

settu_periasamy — Wed, 18 Nov 2015 17:04:11 GMT

Hi,

Like this? if your %value 80 => Give .8

Re: Visual Cues based off expression

Wed, 18 Nov 2015 17:04:56 GMT

Hi Mark,

I am looking at the cues tab, just posted what I was using for the expression if it was needed. I am using a straight table, not a text object.

Re: Visual Cues based off expression

Wed, 18 Nov 2015 17:07:48 GMT

Settu,

Thats what I am trying to do, seems that I was not using .75 for 75%. it is working now.