topic Re: Line Chart - Format Values on Data Points in QlikView

Line Chart - Format Values on Data Points

danielle_v — Tue, 16 Jun 2015 09:27:49 GMT

Hi All,

I have a line chart as per the below where I need to show the values on the data points. As you can see, the values can overlap and therefore become difficult/impossible to read.

Is there a better way of doing this? For example, a way to get the values to show under/on top of the lines? Or even a way to shorten the labels, for example changing '£150,623 to instead show '150k'? I've tried doing this by adding this into the expression in the 'Show Value' option within the expression, but no luck so far.

Any ideas gratefully received!

Re: Line Chart - Format Values on Data Points

tracysmart — Tue, 16 Jun 2015 09:44:19 GMT

Hi Danielle

I too have struggled with this and don't think its possible at the moment to control where they fall, other than resizing the chart or adding a scrollbar to space the lines out a bit more.

I ended up just using 'text as pop up' and added small symbols to guide the user where to hover their cursor. The resulting graph is tidier in the long run.

Re: Line Chart - Format Values on Data Points

Anonymous — Tue, 16 Jun 2015 10:03:07 GMT

Hello,

Under Numbers in the chart properties you can set the Thousand symbol.

But I think you have to divide the value by 1,000, though.

I hope this helps.

Re: Line Chart - Format Values on Data Points

awhitfield — Tue, 16 Jun 2015 10:11:37 GMT

Hi Danielle,

you could do something like this and y=use the cursor hover over to show the values:

See attachment:

Re: Line Chart - Format Values on Data Points

danielle_v — Tue, 16 Jun 2015 13:30:55 GMT

Hi Tracy & Andrew,

Thanks for your helpful suggestions - think I may have to go down this route as it doesn't look like I can do what I intended to

Re: Line Chart - Format Values on Data Points

awhitfield — Tue, 16 Jun 2015 13:32:09 GMT

No problem, there's no a perfect solution to you issue - Have a nice one !

Andy

Re: Line Chart - Format Values on Data Points

prashantbaste — Tue, 16 Jun 2015 13:38:44 GMT

Hi Danielle,

I would suggest you to show one expression (line) values on line it self

and for another expression (line) show values on axis.

But this will be useful only if there are two expressions. Otherwise Tracy's solution will be another way to do.

Regards,

Prashant P Baste

Re: Line Chart - Format Values on Data Points

buzzy996 — Tue, 16 Jun 2015 14:06:32 GMT

may be u like this,

Re: Line Chart - Format Values on Data Points

erjohnso — Tue, 29 Mar 2016 17:13:58 GMT

I am late to the game here, so this may be resolved already however this can be done by formatting the expression on the number tab. See below: