Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Setting background color in a straight table

Hi,

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:

IF([Prices]=Max(TOTAL Sum(Price)),Green())

but it doesn't work; the max function is wrong 'cause if i change the function as follow:

IF([Prices]>10,Green())

it works properly.

Should someone help me with the max function, pls?

Thank you.

N.

1 Solution

Accepted Solutions
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

The easiest way of doing it is by using Rank.

=if(Rank( total Prices)=1,Green())

see attached.

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Kindly provide some sample data...

maxgro
MVP
MVP

maybe

if(sum(Price)=max(total aggr(sum(Price), Dim1)), green(), red())

replace Dim1 with your dim or dims

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

The easiest way of doing it is by using Rank.

=if(Rank( total Prices)=1,Green())

see attached.

Anonymous
Not applicable
Author

Thank you very much!!

Thanks also to the others for the answers.

Have a nice day.

N.