topic Max value per each column in QlikView

Max value per each column

Thu, 29 Sep 2011 10:26:05 GMT

Hi, QlikView gurus

I've got one question regarding pivot calculations. Is there a way how to calculate the maximum value per each column and to add red background color to it?
I belive that it's quite simple, but due to lack of experience I'm out of ideas how to achieve this. I tried couple of methods, but still no luck.

Many thanks in advance

Re: Max value per each column

kaushiknsolanki — Thu, 29 Sep 2011 10:41:18 GMT

HI,

Try this.

Click on + sign next to your expression.

Click on Background color. Add this expression at definition.

=if(sum(EventCount_A) = max(total <Month_A>EventCount_A),rgb(125,125,125))

Click on ok.

Notice the changes.

Also have a look at the attched document.

Regards,

Kaushik Solanki

Max value per each column

Thu, 29 Sep 2011 11:01:36 GMT

Thanks... what else can I say

KR, Walters

Re: Max value per each column

kaushiknsolanki — Fri, 30 Sep 2011 05:53:11 GMT

Hi Walter,

Nothing to say more.

I am glad that my solution worked for you.

Cheers,

Regards,

Kaushik Solanki