Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

edp
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
Not applicable

Re: Setting background color in a straight table

The easiest way of doing it is by using Rank.

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

see attached.

4 Replies
MK_QSL
Not applicable

Re: Setting background color in a straight table

Kindly provide some sample data...

maxgro
Not applicable

Re: Setting background color in a straight table

maybe

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

replace Dim1 with your dim or dims

phaneendra_kunc
Not applicable

Re: Setting background color in a straight table

The easiest way of doing it is by using Rank.

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

see attached.

edp
Not applicable

Re: Setting background color in a straight table

Thank you very much!!

Thanks also to the others for the answers.

Have a nice day.

N.