Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visual Cues based off expression

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,

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi,

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

Capture.JPG

View solution in original post

4 Replies
Mark_Little
Luminary
Luminary

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

settu_periasamy
Master III
Master III

Hi,

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

Capture.JPG

Not applicable
Author

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.

Not applicable
Author

Settu,

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