topic Re: Bar Chart: Expression label inside the bar in QlikView

Bar Chart: Expression label inside the bar

Wed, 24 Apr 2013 12:58:53 GMT

Hi all,

I'm facing an issue.

- I've a bar chart that i'll turn into a waterfall using a bar offset for each expression

- This bar char is composed of 5 expressions.

I would like to have in each bar the label of the expression.

Any Idea?

Re: Bar Chart: Expression label inside the bar

alexandros17 — Wed, 24 Apr 2013 13:12:21 GMT

The only way is (if you have a fixed number of bars) go to tab "Presentation" and in "text in chart" you can add text (even vertically)

hope it helps

Re: Bar Chart: Expression label inside the bar

Gysbert_Wassenaar — Wed, 24 Apr 2013 13:26:54 GMT

Use the dual function: dual('MyLabel', myexpression). Replace MyLabel with the label of the expression and myexpression with the expression itself. The bar will use the text MyLabel to display in the bar and the value of myexpression for the length of the bar.

Re: Bar Chart: Expression label inside the bar

Wed, 24 Apr 2013 13:41:39 GMT

go to properties of bar chart

clik on Number tab

select Expression Default value

then write in symbol = test

then test as a label for expression.

see the attachement.

Re: Bar Chart: Expression label inside the bar

Wed, 24 Apr 2013 15:02:36 GMT

Based on Gysbert answer,

Dual('MyLabel' & chr(10) & num(MyExpression, '0.0%'), MyExpression)

I have now both Expression Name and it's value by the top of the bar.

Many Thanks.

Re: Bar Chart: Expression label inside the bar

Fri, 04 Mar 2016 11:35:37 GMT

Hi, my current chart expression is using : =$(vTotalCompliance) which is a %'age rate.

My Label is Unit

If I try to use Dual(Unit,$(vTotalCompliance)) the label is not appearing within each bar segment.

Do you have any suggestions?

Many thanks for your time

Re: Bar Chart: Expression label inside the bar

wagnepat — Wed, 09 Aug 2017 13:43:38 GMT

Hi Gysbert,

I tried your function but somehow it doesn't work (below you see the expression and the dual function (dark blue = expressen, lightblue = dual function)).

Do you have any idea what I can that it works?

Thank you,

Patrick