Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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 II

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

Community Browser