topic Re: Using visual cues on negative numbers in QlikView

Using visual cues on negative numbers

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

I have the following table in Qlikview which has a mixture of negative and positive numbers. I am trying to use the visual cues to show numbers in red that are less than or equal to five and I also want it to show-1,-2,-3,-4 or -5 as red.

Is there a way to do this?

Thanks

Greg

Re: Using visual cues on negative numbers

Anonymous — Fri, 19 Aug 2016 11:38:05 GMT

I should also have said that the problem is that it is also showing anything less than -5 as red and I don't want it to do that

Re: Using visual cues on negative numbers

hic — Fri, 19 Aug 2016 11:48:04 GMT

I wouldn't use visual cues for this. Instead, I would use a color expression. See for example under Colors in charts.

A color expression is more flexible and can have nested if()-functions or a pick function.

HIC

Re: Using visual cues on negative numbers

sunny_talwar — Fri, 19 Aug 2016 11:48:23 GMT

Do you have a sample you can share here?

Re: Using visual cues on negative numbers

Anonymous — Fri, 19 Aug 2016 11:54:45 GMT

Thanks Henric

I'll try that. But I'm not very good with functions. I'm also already using the text color expression for the first column in the table. What would be the best way to write the expression

Thanks

Greg