topic Re: Reference lines over lap with values on data points in QlikView

Reference lines over lap with values on data points

Wed, 14 Nov 2012 17:07:46 GMT

Hi, I'm new to Qlikview. The reference lines in attached chart are overlapping with the values to make the numbers hard to read. What's the best way to fix this? I tried Plot Values inside Segments, it had the same problem. Text on Axis doesn't look pretty. Suggestions? Thanks in advance!

Re: Reference lines over lap with values on data points

Gysbert_Wassenaar — Wed, 14 Nov 2012 17:30:49 GMT

Your options are limited if you want to keep the values in the chart itself. You can make the lines thinner and change the transparancy of the color,

Re: Reference lines over lap with values on data points

whiteline — Wed, 14 Nov 2012 18:29:11 GMT

Hi.

You could also show the values on axis.

Or use some alternative to reference lines.

For example you could divide your bars into three colorized segments (green, yellow, red).

Re: Reference lines over lap with values on data points

Wed, 14 Nov 2012 18:42:55 GMT

OK, I was hoping there was a way to move these values up, but I tried what you suggested it did look better, Thank you! Hopefully it will pass QA.

Re: Reference lines over lap with values on data points

Wed, 14 Nov 2012 19:02:02 GMT

If the line color is defined by background color of a dimension (Expressions tab, click on +, Definition field) which is

RGB(252,115,98), how to make it semi-transparent?

Re: Reference lines over lap with values on data points

Gysbert_Wassenaar — Wed, 14 Nov 2012 19:04:36 GMT

Use the argb function with as first parameter the alpha value for transparency. R,g and b are the other parameters for the function. Alpha 0 is 100% transparent, 255 is 100% opaque.

Re: Reference lines over lap with values on data points

Wed, 14 Nov 2012 19:12:52 GMT

Thanks so much! You are so helpful!

Re: Reference lines over lap with values on data points

Wed, 14 Nov 2012 19:25:43 GMT

Thanks!