Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for
Did you mean:
Creator II

## Highlight Min, Max and median numbres in table/pivot with colors

Hi All,

Is it possible to highlight Min, Max and Median value with different colours in a table/ Pivot?

my measure is count([CTMP CPTY Reason])

Thanks,

Richard

Labels (1)
• ### QlikSense

2 Solutions

Accepted Solutions

You can use below expression in background color of your measure. Where Dimension1,Dimension2  are pivot table dimensions. You can fill the RGB color values based on requirement

=if( count([CTMP CPTY Reason]) = max(total aggr(count([CTMP CPTY Reason]),Dimension1,Dimension2)), rgb(,,,),

if( count([CTMP CPTY Reason]) = min(total aggr(count([CTMP CPTY Reason]),Dimension1,Dimension2)), rgb(,,,),

if( count([CTMP CPTY Reason]) = median(total aggr(count([CTMP CPTY Reason]),Dimension1,Dimension2)), rgb(,,,))))

So you need to include CTMP CPTY reasons  as well in aggr

12 Replies

You can use below expression in background color of your measure. Where Dimension1,Dimension2  are pivot table dimensions. You can fill the RGB color values based on requirement

=if( count([CTMP CPTY Reason]) = max(total aggr(count([CTMP CPTY Reason]),Dimension1,Dimension2)), rgb(,,,),

if( count([CTMP CPTY Reason]) = min(total aggr(count([CTMP CPTY Reason]),Dimension1,Dimension2)), rgb(,,,),

if( count([CTMP CPTY Reason]) = median(total aggr(count([CTMP CPTY Reason]),Dimension1,Dimension2)), rgb(,,,))))

Creator II
Author

Hi Kush,

I tried as per your suggestion, not sure why only #2 are getting highlighted. I used expression as below -

=if(count([CTMP CPTY Reasons]) = max(total aggr(count([CTMP CPTY Reasons]),[CTMP Joint Touch Statement],[CTMP Market Country])), red(),

if(count([CTMP CPTY Reasons]) = min(total aggr(count([CTMP CPTY Reasons]),[CTMP Joint Touch Statement],[CTMP Market Country])), green(),

if(count([CTMP CPTY Reasons]) = median(total aggr(count([CTMP CPTY Reasons]),[CTMP Joint Touch Statement],[CTMP Market Country])), blue ())))

Regards,

Richard

looks like you have 3 dimensions in pivot table so in aggr you need to include all the dimensions

Creator II
Author

No I just have 2 dimensions -

[CTMP Joint Touch Statement],

[CTMP Market Country] and one measure

count([CTMP CPTY Reasons]

Creator II
Author

That is nothing but CTMP joint touch statement dimension which I have renamed to touched trades 🙂

What is capacity indicator, coupon rate amount then?

Creator II
Author

capacity indicator, coupon rate amount, etc are the reasons listed under CTMP CPTY reasons which we are counting under measure against 2 dimensions

So you need to include CTMP CPTY reasons  as well in aggr

Community Browser