topic Re: Chart: Data labels are over lapping slightly in QlikView

Chart: Data labels are over lapping slightly

Mon, 17 Feb 2014 05:37:55 GMT

Dear Gurus,

I have below chart in one of the dashboard where numbers for Feb 2014 is over lapping, is there any chance we can move data point, similar to what we can do in Excel?

Re: Chart: Data labels are over lapping slightly

whiteline — Mon, 17 Feb 2014 06:01:11 GMT

Hi.

The only way you can use add some invisible symbols to move it horizontally.

Set the number format Expression Default.

Modify your expression:

=dual(repeat(chr(255), 10) & value ,value)

Re: Chart: Data labels are over lapping slightly

Mon, 17 Feb 2014 06:21:20 GMT

uncheck the Forced Zero checkbox it will show effects as u needed the

above image will help u

Re: Chart: Data labels are over lapping slightly

Mon, 17 Feb 2014 06:46:44 GMT

Thanks a lot Whiteline for quiding me in right direction ... in my expression i had ... num(value,'#,##0') .. i just changed to num(value,' #,##0').. it looks better now ...

Re: Chart: Data labels are over lapping slightly

whiteline — Mon, 17 Feb 2014 08:31:38 GMT

Hi.

You can also make the offset various depending on dimension value.

For the top line move them to the left and for the bottom - to the right.

Of course the result depends on the complexity of your data.

I suggest to use sort ranking and odd function.

Re: Chart: Data labels are over lapping slightly

Mon, 17 Feb 2014 08:59:35 GMT

Hi,

Thanks for your reply, How can i offset top line move them to the left? ... can you please provide me some example ...