Discussion Board for collaboration related to QlikView App Development.
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 -
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.
Have a look
Bar Chart Highest Value Coloured
Hope it helps!!
it doesn't. I need get to the previous expression and compare it to current.
Rank() function won't help here
Use this in Expression Tab for Background Color
if(rank(fabs(above(Expression ,1)-Expression ))=1,green())
Hope this solve your problem!!!
Would you be able to share a sample you are working with to play around with it