topic Using expression label on chart axis when no Dimension in QlikView

Using expression label on chart axis when no Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a bar chart with no dimension (as shown below). I would like to be able to use the expression labels on the axis of my bar chart instead of showing them in the legend. Can I?

Re: Using expression label on chart axis when no Dimension

marcus_sommer — Wed, 05 Oct 2016 13:31:03 GMT

You could use a dual-expression like:

dual('YourExpressionLabel - ' & num(YourExpression, '##,0%'), YourExpression)

- Marcus

Re: Using expression label on chart axis when no Dimension

Anonymous — Wed, 05 Oct 2016 13:45:46 GMT

Thanks Marcus. I replaced my expression with the dual-expression but nothing happened.

Re: Using expression label on chart axis when no Dimension

marcus_sommer — Wed, 05 Oct 2016 13:48:09 GMT

Go to the number tab and change the setting to expression-standard.

- Marcus

Re: Using expression label on chart axis when no Dimension

sunny_talwar — Wed, 05 Oct 2016 13:48:16 GMT

I think you will need to use a synthetic dimension or island table as dimension and single expression to achieve this. With only expressions, you won't be able to achieve what you are looking for

Re: Using expression label on chart axis when no Dimension

Frank_Hartmann — Wed, 05 Oct 2016 14:03:51 GMT

see attached

hope this helps!

Re: Using expression label on chart axis when no Dimension

sunny_talwar — Wed, 05 Oct 2016 14:06:53 GMT

I guess I was wrong

Re: Using expression label on chart axis when no Dimension

Anonymous — Wed, 05 Oct 2016 14:09:10 GMT

Thanks Marcus. That worked but the label and the value both sat to the right of the bar.

I managed to resolve this without the dual expression. I found that when I switched off the legend the expression label automatically acted as a dimension label as shown below -

Re: Using expression label on chart axis when no Dimension

sunny_talwar — Wed, 05 Oct 2016 14:09:28 GMT

Frank -

Do you mind sharing the settings that allowed you to do this or is this the default?

Re: Using expression label on chart axis when no Dimension

Anonymous — Wed, 05 Oct 2016 14:10:23 GMT

Thanks Frank

Re: Using expression label on chart axis when no Dimension

Frank_Hartmann — Wed, 05 Oct 2016 14:14:24 GMT

just make sure that in expression tab "Expression as Legend" is selected but under Presentationtab "show legend"

is unselected 🙂

Re: Using expression label on chart axis when no Dimension

sunny_talwar — Wed, 05 Oct 2016 14:15:41 GMT

Awesome

Thanks for sharing that information.

Best,

Sunny