topic How do I show all values on data points in QlikView

How do I show all values on data points

Anonymous — Tue, 17 Feb 2015 11:17:21 GMT

How do I show all values on data points in a bar chart even when there isn't enough room. In the chart below some values are not appearing (dark blue segment of chart - 'special programmes'). Can I force it to appear?

Re: How do I show all values on data points

Frank_Hartmann — Tue, 17 Feb 2015 12:14:46 GMT

Hi Greg,

I think this would only work if you set the textsize of the values to a lower level than the existing textsize!

Cheers

Re: How do I show all values on data points

jonathandienst — Tue, 17 Feb 2015 13:17:40 GMT

QV will not place the text if the space is too small. To the best of my knowledge, there is no way to override that behaviour. Your other option is to play with text on the axis or to sort the data so that the small bar is at the top (you may need to turn off text in bars).

You could also create a text only expression that contains all the amounts. Turn off text for all expressions except this one and turn this one on (use a combo chart and turn off bar, line and symbol) You will need to turn off text in bars.

HTH

Jonathan

Re: How do I show all values on data points

Wed, 18 Feb 2015 02:23:54 GMT

You can show the values outside data points. That may solve your problem.

Re: How do I show all values on data points

buzzy996 — Wed, 18 Feb 2015 17:49:20 GMT

can u try by creating y-axis2 and show the special program values exp on tht axis.

Re: How do I show all values on data points

Anonymous — Thu, 19 Feb 2015 07:36:14 GMT

Thanks Aman. How do I do that?

Re: How do I show all values on data points

Anonymous — Thu, 19 Feb 2015 07:40:28 GMT

How do I create a y-axis2?

Thanks

Greg

Re: How do I show all values on data points

buzzy996 — Thu, 19 Feb 2015 10:25:50 GMT

for 2nd expression (special program) calculations from AXES tab choose the POSITION Right(Top).

hopes it makes the difference.