topic Re: Setting background color in a straight table in QlikView

Setting background color in a straight table

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Setting background color in a straight table

MK_QSL — Wed, 10 Sep 2014 15:35:26 GMT

Kindly provide some sample data...

Re: Setting background color in a straight table

maxgro — Wed, 10 Sep 2014 16:06:33 GMT

maybe

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

replace Dim1 with your dim or dims

Re: Setting background color in a straight table

phaneendra_kunc — Wed, 10 Sep 2014 16:20:31 GMT

The easiest way of doing it is by using Rank.

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

see attached.

Re: Setting background color in a straight table

Anonymous — Thu, 11 Sep 2014 06:06:00 GMT

Thank you very much!!

Thanks also to the others for the answers.

Have a nice day.