topic Re: Increase space between dimension and text on axis values in QlikView

Increase space between dimension and text on axis values

Fri, 16 Oct 2015 23:07:20 GMT

Hi everyone,

I'd like to add some space between my dimension lables and the numeric values along the Y axis, as highlighted in the attached chart, so they don't appear bunched up.

Thanks!

Scott

Re: Increase space between dimension and text on axis values

petter — Mon, 19 Oct 2015 17:26:27 GMT

You can just add some spaces in front of your expression to add the necessary padding:

Re: Increase space between dimension and text on axis values

maxgro — Mon, 19 Oct 2015 17:32:41 GMT

If I understand,

you can use ctrl+shift and then move the red rectangle

and in the "Axis" tab uncheck "Truncate Label" (but alignment is left)

Here an example of the output

Re: Increase space between dimension and text on axis values

Mon, 19 Oct 2015 18:46:38 GMT

Thanks Petter.

That didn't work. Something is required between ' '. If I just put blank spaces, it is not reflected in the the graph.

I was able to solve my problem by reducing the font size and that works for now, but I woudl still like to know how to do this while also maintaining the right justification of the dimension lables.

Re: Increase space between dimension and text on axis values

sumeet-vaidya — Tue, 20 Oct 2015 06:05:24 GMT

Hi Scott,

The solution given by Petter works absolutely fine. You need to write your expression as below with preceding spaces. No need to reduce your font size as well.

= ' ' & Sum(VALUE)

Regards

Sumeet

Re: Increase space between dimension and text on axis values

krishna20 — Tue, 20 Oct 2015 07:19:36 GMT

Hi,

Create a variable like vSpace then assign value =repeat(' ',8).

Goto your expression ->vspace & sum(Amount).

Hope it helps

Re: Increase space between dimension and text on axis values

Tue, 20 Oct 2015 15:24:23 GMT

Hi Sumeet,

It tired the expression again as you suggested and it's still not working. Check out the image below that shows my expression and results.

Re: Increase space between dimension and text on axis values

Tue, 20 Oct 2015 15:28:03 GMT

Hey krishna20,

I created with the variable as you suggested and it's not working. Am I missing something?

Re: Increase space between dimension and text on axis values

swuehl — Tue, 20 Oct 2015 17:55:02 GMT

What if you change the dimension values instead, a calculated dimension like

=[Device Activity Status] & ' '

Re: Increase space between dimension and text on axis values

Tue, 20 Oct 2015 21:57:45 GMT

Hey swuehl ,

I tried that and it didn't work either.

I'm struggling with this because it seems like this type of answer, where additional spacing is added, is working for folks, but it's not having any impact on my chart.

Re: Increase space between dimension and text on axis values

Tue, 20 Oct 2015 22:08:33 GMT

This solution works when I have a single expression in my chart. However, my chart contains 2 expressions and even when I add spacing on one or both of the expressions, I don't see a change.

Re: Increase space between dimension and text on axis values

krishna20 — Wed, 21 Oct 2015 04:58:18 GMT

Hi,

Remove '$ ' before variable and try.

Re: Increase space between dimension and text on axis values

sumeet-vaidya — Wed, 21 Oct 2015 05:11:52 GMT

Hi Scott,

I am unable to figure out why it is not working with your object. As the solution of preceding spaces works fine in my chart. Please see below.

Regards

Sumeet

Re: Increase space between dimension and text on axis values

raman_rastogi — Wed, 21 Oct 2015 05:28:10 GMT

Change Font Property of bar Chart Object

font->default font->text objects/buttons->Set

and use ctrl+Shift To change chart Layout

I hope it ll Work

Re: Increase space between dimension and text on axis values

jsingh71 — Wed, 21 Oct 2015 05:38:08 GMT

share your sample app.

Re: Increase space between dimension and text on axis values

Wed, 21 Oct 2015 15:29:22 GMT

Attached is a sample application displaying the issue.

Re: Increase space between dimension and text on axis values

swuehl — Wed, 21 Oct 2015 17:52:38 GMT

Maybe like attached?

Re: Increase space between dimension and text on axis values

Anonymous — Wed, 21 Oct 2015 18:30:41 GMT

Hi Scott,

You can use ANSI code chr(160) to have as many Space you want.

Regards.

Imran K

Re: Increase space between dimension and text on axis values

luizmendes118 — Wed, 21 Oct 2015 19:05:15 GMT

Like this attached?

Re: Increase space between dimension and text on axis values

Thu, 22 Oct 2015 21:17:37 GMT

That did the trick! Thanks Luiz!