topic Re: IF EXPRESSION in QlikView

IF EXPRESSION

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

Happy New year everyone, I hope everyone had a good time.

Could someone please advise what am I doing wrong in the below expression.

if([Trust Spend] = "Actual Trust Spend",Green(), Red())

The “Actual Trust Spend” is a label not a field name and I keep getting : RGB(0,128,0) as an answer.

Re: IF EXPRESSION

MohammedMustaq — Thu, 03 Jan 2019 13:08:47 GMT

Happy New Year dear!

Try with Single Quotes instead of Double " "

=if([Trust Spend] = 'Actual Trust Spend',Green(), Red())

Regards

Mustaq

Re: IF EXPRESSION

solomonadjei — Thu, 03 Jan 2019 13:27:01 GMT

Thanks for your rapid respond Mustaq.
Still not working 😞

Re: IF EXPRESSION

MohammedMustaq — Thu, 03 Jan 2019 13:42:05 GMT

Can you attach the sample data with your desired output.

it would be easy to understand and solve.

Regards

Mustaq

Re: IF EXPRESSION

solomonadjei — Thu, 03 Jan 2019 14:01:20 GMT

Hi Mustag,
I have attached image of the view.

Re: IF EXPRESSION

bgerchikov — Thu, 03 Jan 2019 19:04:35 GMT

If Actual Trust Spend is a column label, same as Trust Spend. Should be like this:

if([Trust Spend] = [Actual Trust Spend],Green(), Red())

Good luck!

Re: IF EXPRESSION

solomonadjei — Fri, 04 Jan 2019 12:13:29 GMT

Thanks for your input

The [Actual trust spend] is a label name in the chart properties and am not getting the result am looking for.

Re: IF EXPRESSION

sunny_talwar — Fri, 04 Jan 2019 12:41:11 GMT

What are you hoping to see here? You have used a color expression as a main expression.... So, because Trust Spend <> Actual Trust Spend... you are seeing the RGB() representation of Red(). What are you looking to get?

Re: IF EXPRESSION

solomonadjei — Mon, 07 Jan 2019 09:01:31 GMT

Morning Sunny,
Am hoping to see if any number in the [Actual Trust Spend] field does not match with the Trust Spend should turn RED and a direct match should turn GREEN. The issue I have here is that, the [Actual Trust Spend] is not a field name in the table, it’s just a label name in the chart properties tab. Is there a way o can achieve this ?
Thanks

Re: IF EXPRESSION

sunny_talwar — Mon, 07 Jan 2019 12:10:13 GMT

You sure can, but what you need to do is to use your expression as a background color expression and not just the main expression. Does that make sense?

Re: IF EXPRESSION

solomonadjei — Mon, 07 Jan 2019 12:55:58 GMT

Thanks very much Sunny, it worked 🙂