Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
tomerdagan123
Contributor III
Contributor III

Highlight bars in bar Chart

Hi,

Is there any way to highlight defined differences in a bar charts between to preceding months?

for example I would like to highlight the bar of oct 2015 with a red dot since the jump between sep 2015 is big -

Capture444.JPG

notes-

tried before/above functions but it is not working on bar charts. only on pivot tables.

I prefer to use a UI option rather than implementing it on script.

4 Replies
qlikviewnovice
Specialist II
Specialist II

Hi,

Have a look

Bar Chart Highest Value Coloured

Hope it helps!!

tomerdagan123
Contributor III
Contributor III
Author

it doesn't. I need get to the previous expression and compare it to current.

Rank() function won't help here

abhinav301
Contributor II
Contributor II

Hi,

Use this in Expression Tab for Background Color

if(rank(fabs(above(Expression ,1)-Expression ))=1,green())

e.g.:

if(rank(fabs(above(sum(Qty),1)-Sum(Qty)))=1,green())

Hope this solve your problem!!!

sunny_talwar

Would you be able to share a sample you are working with to play around with it