Solved: Max value per each column - Qlik Community

Report Inappropriate Content · ‎2011-09-29

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

kaushiknsolanki · ‎2011-09-29

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2011-09-29

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-09-29

Thanks... what else can I say

KR, Walters

kaushiknsolanki · ‎2011-09-30

Hi Walter,

Nothing to say more.

I am glad that my solution worked for you.

Cheers,

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!