topic Re: Label Dimension in QlikView

Label Dimension

inescastelhano — Wed, 26 Aug 2015 10:52:17 GMT

Hi there,

I'm facing a problem building a bar chart.

I have two expressions (1 and 2). For each of them I would like to have a label on the horizontal axis, instead of a legend on the right (as displayed in the picture) but I can't get it to work.

Does anyone have a clue on how to do it?

Thanks in advance.

Cheers,

Inês

Re: Label Dimension

MarcoWedel — Wed, 26 Aug 2015 11:10:01 GMT

Hi,

you could use the Valuelist function in a calculated dimension and contract your two expressions into one using Pick(Match(Valuelist, ... , ...), ... , ...)

hope this helps

regards

Marco

Re: Label Dimension

Anonymous — Wed, 26 Aug 2015 11:11:01 GMT

This is an easy one, go to the presentation tab in the object properties and un-tick the "Show Legend" option. This will give the result you need. Hope this works for you.

Re: Label Dimension

MarcoWedel — Wed, 26 Aug 2015 11:20:45 GMT

one example:

hope this helps

regards

Marco

Re: Label Dimension

inescastelhano — Wed, 26 Aug 2015 11:25:13 GMT

Thank you! This is exactly what I was looking for.

It worked perfectly. I didn't know these functions, since I'm still quite new to QV.

Cheers,

Inês

Re: Label Dimension

inescastelhano — Wed, 26 Aug 2015 11:26:31 GMT

Thanks for your answer However, this would just disable the legend. What I wanted was to get the legend text but in the axis.

Cheers

Re: Label Dimension

Anonymous — Wed, 26 Aug 2015 11:33:58 GMT

Ok that is also no problem, just click on the object then hold down the Ctrl and Shift key at the same time. Red lines will appear around the elements in the chart. You can then make the bar chart bit a little smaller and wider and you can drag the legend box to thew bottom of the chart. If you make it wide you can then actually get the bits of the legend next to each other.

Re: Label Dimension

Anonymous — Wed, 26 Aug 2015 11:35:22 GMT

Oh yes and by disabling the legend the names of the expressions will appear under each bar without the need for complex expressions.

Re: Label Dimension

MarcoWedel — Wed, 26 Aug 2015 11:41:02 GMT

indeed, much simpler.

thank you

regards

Marco