topic Highlight bars in bar Chart in QlikView

Highlight bars in bar Chart

Anonymous — Thu, 30 Jun 2016 09:36:14 GMT

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 -

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.

Anonymous — Thu, 30 Jun 2016 09:48:37 GMT

Hi,

Have a look

Hope it helps!!

Anonymous — Thu, 30 Jun 2016 10:25:12 GMT

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

Rank() function won't help here

Anonymous — Thu, 30 Jun 2016 12:11:29 GMT

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 — Thu, 30 Jun 2016 17:01:42 GMT

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