topic Bar Chart x- Axis value in QlikView

Bar Chart x- Axis value

tamilarasu — Thu, 25 Aug 2016 04:17:26 GMT

Hello All,

I am creating a bar chart and used dual function in each expression to show desired label on the bars. Also, I have used text on axis point option to show the sum value. Currently, I could see the labels are displayed in the x- axis also. But I wish to show the sum value in the x-axis. Attached a screen shot and Sample file for better understanding.

Any help will be appreciated.

Re: Bar Chart x- Axis value

avinashelite — Thu, 25 Aug 2016 04:36:24 GMT

I don't think this is possible like as you excepted . But you could change your expression for a better representation

Try this :

Dual('1'&'('&Sum([In Scope])&')', sum([In Scope]))

Re: Bar Chart x- Axis value

Thu, 25 Aug 2016 05:31:53 GMT

I think it is not possible in chart but you can place 2 text boxes on x-axis & give expression - Sum([In Scope]) & sum([Out of Scope]) respectively.

Re: Bar Chart x- Axis value

tamilarasu — Thu, 25 Aug 2016 05:48:01 GMT

Hi Avinash,

Thank you. That's my final option. I would like to know If there is any other work around for this.