topic Re: Bar Chart Highest Value Coloured in QlikView

Bar Chart Highest Value Coloured

Anonymous — Fri, 17 Jul 2015 15:05:32 GMT

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

sunny_talwar — Fri, 17 Jul 2015 15:08:54 GMT

Use color expression:

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

MK_QSL — Fri, 17 Jul 2015 15:10:01 GMT

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())

Anonymous — Fri, 17 Jul 2015 15:10:39 GMT

Thank you so much everyone! Problem solved.

sunny_talwar — Fri, 17 Jul 2015 15:11:44 GMT

Here please find attached a sample:

rustyfishbones — Fri, 17 Jul 2015 15:11:58 GMT

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

rustyfishbones — Fri, 17 Jul 2015 15:12:57 GMT

I was too slow in my attempt to help