Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

solomonadjei
New Contributor III

*** EXPRESSION ***

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

 

111114.PNG

 

 

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: *** EXPRESSION ***

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

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

 

-Rob

5 Replies
miguelbraga
Valued Contributor III

Re: *** EXPRESSION ***

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: *** EXPRESSION ***

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

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

 

-Rob

solomonadjei
New Contributor III

Re: *** EXPRESSION ***

Thanks miguelbraga Smiley Happy
solomonadjei
New Contributor III

Re: *** EXPRESSION ***

Thanks very much Smiley Happy.
It worked.
Gabriel
Valued Contributor III

Re: *** EXPRESSION ***

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