Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a question around bar charts and colour displays.
I have a requirement in a bar chart to set the colour of the bar chart values over a range to a certain colour while others below the range are a different colour.
For example:
I have a bar chart over time. In Jan-11, I have a value of 10 for the bar. I have a reference line in the chart at 7.
I would like the lower part of the Jan bar to be green for values between 0 and 7, while all the parts above the reference line and greater than 7 should be red. I doubt this can actually be done in QlikView, but if there is a way to do it, I would be glad for someone to point me in the right direction.
Thank you
Yee of Little Qlikview Faith.
Solution attached (hopefully).
Uses a calculated Stacked Bar Chart to achieve the effect you're after.
Look at the script and Chart Properties to see how its done.
Hope that helps,
Matt - Visual Analytics Ltd
Yee of Little Qlikview Faith.
Solution attached (hopefully).
Uses a calculated Stacked Bar Chart to achieve the effect you're after.
Look at the script and Chart Properties to see how its done.
Hope that helps,
Matt - Visual Analytics Ltd
Cheers for that Matt.
Nice work around to get it working using the stacked chart. I am still a bit curious to know if it is possible with a normal bar chart.
Thanks anyway
good to see the tool power