Discussion board where members can get started with QlikView.
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?
Go to Solution.
Use color expression:
If(Rank(YourExpression) = 1,Green(), Blue())
Consider that you have below Bar Chart
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())
Thank you so much everyone! Problem solved.
Here please find attached a sample:
You can try something like this in the Expression definition for the background color
I was too slow in my attempt to help