Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.

Not applicable

Max value per each column

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

1 Solution

Accepted Solutions

Re: Max value per each column

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

3 Replies

Re: Max value per each column

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

Not applicable

Max value per each column

Thanks... what else can I say

KR, Walters

Re: Max value per each column

Hi Walter,

   Nothing to say more.  

   

   I am glad that my solution worked for you.

   Cheers,

Regards,

Kaushik Solanki

Community Browser