topic Re: Green Red coloring expression in QlikView

Green Red coloring expression

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

Hi All,

Pretty New to Qlik Sense:

I created a scatter plot, all data is from the same table, and my dimension is the Sales Rep

I want to highlight in green when Sales Reps achieved above targets in green and in red when below. The following formula does not work though, everything is red... (and should not, by the way)

if(Sum([Actual Sales]) - Sum([Sales Targets])>0, rgb(50,205,50),rgb(255,0,0))

Thanks

Re: Green Red coloring expression

aunahsan — Thu, 26 Apr 2018 15:56:27 GMT

Hi Peter, where are you using your expression for colours?, i cant see why this wouldn't work.

in Qlik sense you can go to appearance > Colors and legends > by expression (from drop down), this is where you would enter that expression.

Re: Green Red coloring expression

petervdb — Thu, 26 Apr 2018 16:03:04 GMT

Thank you for confirming syntax was good. I actually just realized I was using the wrong field (very similar name to the one I needed).

Now looks fancy