topic Re: Data labels positions in QlikView

Data labels positions

mkas0001 — Wed, 27 May 2015 21:20:20 GMT

Hi guys !

I'm beginner in QlikView.

How can i put data labels below for one expression/line and above for another (just like in attached screen) ?

I cannot solve this question.

Thanks

Re: Data labels positions

marcus_sommer — Thu, 28 May 2015 20:32:22 GMT

QV isn't very flexible by positioning data-labels. You could try to set the data-labels within the segments but I don't believe it will be enough difference between the two lines.

You could also try to create a third line on a second axis by which the line will be hidden (inactive or with transparent colors) or you used two charts which are overlapping each other (with diverse layout adjustments).

- Marcus

Re: Data labels positions

rwunderlich — Thu, 28 May 2015 22:14:04 GMT

Download this example from the QlikView Cookbook.

Tutorial - Annotating Chart Data Points http://qlikviewcookbook.com/recipes/download-info/tutorial-annotating-chart-data-points/

Look at the very last example on the "Line Chart" sheet. It demonstrates additional expressions as invisible bars in a Combo chart to position labels. Using a dual() value let's you display the correct value but offset the position one way or another.

This is similar to Marcus's suggestion of using an invisible line but I find it easier with invisible bars.

-Rob

http://masterssummit.com

http://robwunderlich.com