topic Re: Left align labels inside barchart in QlikView

Left align labels inside barchart

Tue, 14 Jun 2016 06:53:47 GMT

Hello,

Is it possible to align labels to the left when my values are inside the bar chart?

I have managed to get the values plotted inside the bar chart as I wanted, but the label is not obviously not in centered along all the bar chart, just centered with the bar where the number is inside.

So, it would be maybe nice to align the number to the left instead of center, can this be done?

Cheers,

Niko

Re: Left align labels inside barchart

pipuindia99 — Tue, 14 Jun 2016 06:59:18 GMT

There is a way, instead of putting the values in Bar you can add those expressions in Text in Chart box and align the numbers to start of the Bar. so that the numbers will be in left always.

Re: Left align labels inside barchart

Anonymous — Tue, 14 Jun 2016 07:05:10 GMT

Hi Niko,

By default the numbers inside are showing on center of line. If you want do it you need 2 expressions. See attached.

Regards!

Re: Left align labels inside barchart

Tue, 14 Jun 2016 07:20:11 GMT

Hello Manuel,

This works otherwise perfectly, but when I try to set the number format, I only get 0,00

Cheers,

Niko

Re: Left align labels inside barchart

Anonymous — Tue, 14 Jun 2016 07:26:46 GMT

Hi Niko,

I am using Dual function, get format on expression and set on number Expression Default.

Dual(Num(Sum(Expression1),'#.##0'),0)

Regards!

Re: Left align labels inside barchart

Tue, 14 Jun 2016 07:30:19 GMT

Ahh, it had to be inside the dual.. I tried to put it outside of the dual()

Now I only have to get the percent mark in place there too.. But thank you very much!

Cheers,

Niko

Re: Left align labels inside barchart

Tue, 14 Jun 2016 07:30:56 GMT

Got that % also there.. Had to be also inside dual(), heh!

Re: Left align labels inside barchart

Anonymous — Tue, 14 Jun 2016 07:33:12 GMT

Hi Niko,

if you want on %, then Dual(Num(Sum(Expression1),'#.##0 %'),0)

Regards!!!