Pivot Table Highlight Max Column

sidjustice — Wed, 25 Nov 2020 16:16:04 GMT

Hi I have some sample data that needs to be shown in a pivot table. Now I need to highlight the column (say background color) which has the highest revenue when the Mode column in collapsed. Like so

Make	Mode	Region	Central	East	West
Honda	Nom		12466	12831	11653
	Sub		11126	11433	10534
	Tur		14259	14880	13155
	vs		9278	8656	8987

So I far I have been trying with the Max, but not able to get it to work

Max ( aggr (NODISTINCT sum(Revenue) , Make, Mode, Region))

Attached qlikview document with inline data

Appreciate any help, Cheers

Sid

Re: Pivot Table Highlight Max Column

sunny_talwar — Tue, 23 Jan 2018 03:30:25 GMT

Try this

=If(Revenue = Max(TOTAL <Make, Mode>Aggr(Sum(Revenue), Make, Mode, Region)), Red())

Re: Pivot Table Highlight Max Column

sidjustice — Tue, 23 Jan 2018 05:18:17 GMT

Sweet, thanks for the quick reply

topic Pivot Table Highlight Max Column in QlikView

Pivot Table Highlight Max Column

Re: Pivot Table Highlight Max Column

Re: Pivot Table Highlight Max Column