Discussion board where members can get started with QlikView.
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.
Go to Solution.
I think you need to include a TOTAL parm to consider all prices.
=if(min(TOTAL [Current Price]) = [Current Price], Yellow(), White())
try creating a variable like this
Then use the variable in your IF statement for background color
=IF([Current Price] = $(v_MinCurrentPrice), Yellow())
Let me know if it works