Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
garethct
Contributor

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

Re: Bar Chart Highest Value Coloured

Use color expression:

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

6 Replies

Re: Bar Chart Highest Value Coloured

Use color expression:

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

MVP
MVP

Re: Bar Chart Highest Value Coloured

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
Contributor

Re: Bar Chart Highest Value Coloured

Thank you so much everyone! Problem solved.

Re: Bar Chart Highest Value Coloured

Here please find attached a sample:

Capture.PNG

rustyfishbones
Honored Contributor II

Re: Bar Chart Highest Value Coloured

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

2015-07-17_1608.png

rustyfishbones
Honored Contributor II

Re: Bar Chart Highest Value Coloured

I was too slow in my attempt to help