Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
sidjustice
New Contributor II

Pivot Table Highlight Max Column

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

MakeModeRegionCentralEastWest
HondaNom124661283111653
Sub111261143310534
Tur142591488013155
vs927886568987

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

1 Solution

Accepted Solutions

Re: Pivot Table Highlight Max Column

Try this

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

Capture.PNG

View solution in original post

2 Replies

Re: Pivot Table Highlight Max Column

Try this

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

Capture.PNG

View solution in original post

Highlighted
sidjustice
New Contributor II

Re: Pivot Table Highlight Max Column

Sweet, thanks for the quick reply