topic Re: * EXPRESSION * in QlikView

* EXPRESSION *

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

Afternoon Experts,

Am struggling to write an expression to highlight or give me a background colour for the least Current Price highlighted in yellow based on my selection. I would appreciate if anyone could help.

Thanks

Re: * EXPRESSION *

miguelbraga — Wed, 09 Jan 2019 16:09:03 GMT

Hey there,

You could make an expression like this in the background section of the Current Price expression:
=if(min([Current Price]) = [Current Price], Yellow(), White())

I think that this will work for you.

PS: please take note that the field [Current Price] need to be replaced with your expression.

Best regards,
MB

Re: * EXPRESSION *

rwunderlich — Wed, 09 Jan 2019 16:29:40 GMT

I think you need to include a TOTAL parm to consider all prices.

=if(min(TOTAL [Current Price]) = [Current Price], Yellow(), White())

-Rob

Re: * EXPRESSION *

solomonadjei — Wed, 09 Jan 2019 16:36:33 GMT

Thanks miguelbraga 🙂

Re: * EXPRESSION *

solomonadjei — Wed, 09 Jan 2019 16:39:18 GMT

Thanks very much :).
It worked.

Re: * EXPRESSION *

Gabriel — Wed, 09 Jan 2019 16:43:58 GMT

Hi,

try creating a variable like this

=MIN([Current Price])

Then use the variable in your IF statement for background color

=IF([Current Price] = $(v_MinCurrentPrice), Yellow())

Let me know if it works

topic Re: *** EXPRESSION *** in QlikView

*** EXPRESSION ***

Re: *** EXPRESSION ***

Re: *** EXPRESSION ***

Re: *** EXPRESSION ***

Re: *** EXPRESSION ***

Re: *** EXPRESSION ***

topic Re: * EXPRESSION * in QlikView

* EXPRESSION *

Re: * EXPRESSION *

Re: * EXPRESSION *

Re: * EXPRESSION *

Re: * EXPRESSION *

Re: * EXPRESSION *