Discussion Board for collaboration related to QlikView Deployment.
I'd like to set a particular background color in a straight table when a value in a specific columns is equivalent to the max of the values of the same column.
The value of the colums is calculate as Sum(Price) and the columns name is "Prices"
I set the background color function as follow:
but it doesn't work; the max function is wrong 'cause if i change the function as follow:
it works properly.
Should someone help me with the max function, pls?
Go to Solution.
The easiest way of doing it is by using Rank.
=if(Rank( total Prices)=1,Green())
Kindly provide some sample data...
if(sum(Price)=max(total aggr(sum(Price), Dim1)), green(), red())
replace Dim1 with your dim or dims
Thank you very much!!
Thanks also to the others for the answers.
Have a nice day.