topic Re: Bar chart: prevent auto-adjust to data in QlikView

Bar chart: prevent auto-adjust to data

kmarsden — Fri, 25 Sep 2015 16:16:57 GMT

Hi,

Is there a way of fixing the position of the axis on a horizontal bar chart regardless of the dimension values?

I want to future proof a chart and have overlaid some text boxes so the position of the chart is key. If a dimension value is returned with different lengths in the future the chart will shift and all the text boxes are mis-aligned, it's very annoying!

Re: Bar chart: prevent auto-adjust to data

Fri, 25 Sep 2015 16:56:56 GMT

Have you tried perform a Ctrl+Shift keys - that will place red borders the legend are chart area - you can drag the borders to make the chart are wider or longer

Re: Bar chart: prevent auto-adjust to data

marcus_sommer — Fri, 25 Sep 2015 17:42:14 GMT

Maybe you used a string-function to prevent this, like: mid(YourDimension, 1, 10). If then your dimension-values not more unique then this needs some more logic but at first you could try it so.

- Marcus

Re: Bar chart: prevent auto-adjust to data

kmarsden — Tue, 29 Sep 2015 14:25:32 GMT

I think I going to try something similar. I'm going to create a dummy record with a long string length which will be linked to each row in that dimension field. I can then hide it and use a string function to truncate anything that has a longer string length than the dummy record. It's not ideal but I don't see an easier way.

If anyone out there is aware of a more elegant way I'd be grateful if you could share...

Re: Bar chart: prevent auto-adjust to data

kmarsden — Tue, 29 Sep 2015 14:26:33 GMT

This gave me an idea for a workaround so thank you for taking a look

Re: Bar chart: prevent auto-adjust to data

marcus_sommer — Tue, 29 Sep 2015 14:37:25 GMT

I would try it without the dummy-record by doing something like this:

mid(YourDimension, 1, if(len(YourDimension) < 11, 10, len(YourDimension)) &

if(len(YourDimension) < 10, repeat(chr(32), 10 - len(YourDimension), '')

Maybe it needs some attempts to find a fill-char which will be accepted but there are various space-chars possible, see here what I mean: Container.

- Marcus

Re: Bar chart: prevent auto-adjust to data

kmarsden — Mon, 05 Oct 2015 12:21:46 GMT

Hi Marcus, I see what you mean. I've now tried this and going to use it with some minor adjustments to suit my needs. Thanks for your help.