Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
garethct
Creator
Creator

Bar Chart Highest Value Coloured

Hi all,

I've looked everywhere but I can't find my answer.

I'm trying to highlight the bar with the highest value in my bar chart by colouring it green.

Can anyone help?

Thanks

Gareth

1 Solution

Accepted Solutions
sunny_talwar

Use color expression:

If(Rank(YourExpression) = 1,Green(), Blue())

View solution in original post

6 Replies
sunny_talwar

Use color expression:

If(Rank(YourExpression) = 1,Green(), Blue())

View solution in original post

MK_QSL
MVP
MVP

Consider that you have below Bar Chart

Dimension

Customer

Expression

SUM(Sales)

Now go to Expression Tab

Click on + sign and write below expression in BackGround Color

IF(SUM(Sales) = Max(TOTAL Aggr(SUM(Sales),Customer)),Green())

garethct
Creator
Creator
Author

Thank you so much everyone! Problem solved.

sunny_talwar

Here please find attached a sample:

Capture.PNG

rustyfishbones
Master II
Master II

You can try something like this in the Expression definition for the background color

2015-07-17_1608.png

rustyfishbones
Master II
Master II

I was too slow in my attempt to help