topic Re: chart labels on right axis in QlikView

chart labels on right axis

Wed, 31 Aug 2011 10:44:16 GMT

Hi all

Is it possible to right align the bars in a Horizontal bar chart? Basically i would like to have two charts with the titles displayed once in the middle

Thanks

Dan

Re: chart labels on right axis

swuehl — Wed, 31 Aug 2011 11:40:08 GMT

Hi Dan,

is attached something you were looking for?

Unless I missed a simple solution, it's kind of real kludge.

Regards,

Stefan

Re: chart labels on right axis

Wed, 31 Aug 2011 11:44:34 GMT

hi Stefan,

That is excatly what i am after. How did you right align the bars?

I can not see a simple solution either. It would be nice if there was.

Thank you.

Dan

Re: chart labels on right axis

swuehl — Wed, 31 Aug 2011 12:52:03 GMT

Here you go:

My idea was to use negative scale for left chart, this will result on Axis to the right / right aligned bars.

So I used a '-' in both expression on the left chart to get negative values.

Problem is that you don't want to show the values as negative.

Here I used number formatting, there is an optional format specifier for negative numbers (see format tab (ah, I just see that this is hard to see since I replaced the expression labels by blank, but there are expression number formats set ;-)), I just set the format to show same as positive (without minus). This affects the values on bars and the tool tip.

Unfortunately the axis will still show negative values, so I removed the axis (maybe I missed a simple solution here).

We should use same absolute scale range for both charts, I set it manually to 0 to 15, but it should be good to enter enter an expression here that checks both charts value ranges and set the same value. Even if you don't see the axis drawn, I think different scale ranges will be misleading.

The rest is mostly formatting (remove all expression labels, use text boxes instead, etc).

I added another version of the chart where you could probably better see what I did, as I said, it's a hack.

Hope I haven't missed anything, if you have problems, give me a note.

Regards,

Stefan

Re: chart labels on right axis

Thu, 01 Sep 2011 12:22:43 GMT

Hi Stefan

many thanks for your solution.

Dan

Re: chart labels on right axis

Thu, 01 Sep 2011 12:23:02 GMT

Hi Stefan

many thanks for your solution.

Dan

Re: chart labels on right axis

paulyeo11 — Fri, 16 Aug 2013 09:39:33 GMT

Hi Swuehl

you are very creative , able to think out of box.