topic Re: Bar Chart - Axis Scale in QlikView

Bar Chart - Axis Scale

Saravanan_Desingh — Tue, 26 Apr 2016 00:05:20 GMT

I have a situation.

I'm using Dual in the expression to show the data with Text.

But, the scale is not converted into %.

Can you please advise, how to convert the scale in %? Thanks.

Re: Bar Chart - Axis Scale

sunny_talwar — Tue, 26 Apr 2016 00:36:55 GMT

Add another expression ahead of all other expression and give it value 0 and try using % format for the expression on the numbers tab and see if that helps

Re: Bar Chart - Axis Scale

trdandamudi — Tue, 26 Apr 2016 00:38:57 GMT

For your Expression under properties--> Number: Select Integer and then put a check mark for "Show in Percent(%).

See the attached screen shot. Hope this helps,

Re: Bar Chart - Axis Scale

sunny_talwar — Tue, 26 Apr 2016 00:49:20 GMT

So far it isn't working, but I am trying

Re: Bar Chart - Axis Scale

sunny_talwar — Tue, 26 Apr 2016 00:58:23 GMT

Got it, try the attached

Re: Bar Chart - Axis Scale

Saravanan_Desingh — Tue, 26 Apr 2016 01:05:09 GMT

Hi Thirumala,

Thanks for your response.

As I said, I'm using Dual in the expression to display Text. If I change the properties to integer, the display will be turned to numeric, which I dont want to do it. Hope you understand.

Re: Bar Chart - Axis Scale

Saravanan_Desingh — Tue, 26 Apr 2016 01:09:06 GMT

Thanks sunindia‌.

I will get back to you tomorrow after implementing your idea. Actually I was using synthetic dimension (ValueList).

Let me try it tomorrow. Thanks.

Re: Bar Chart - Axis Scale

sunny_talwar — Tue, 26 Apr 2016 01:10:04 GMT

Ya sure thing. I think this should work with a synthetic dimension as well. Are both the dimensions synthetic?

Re: Bar Chart - Axis Scale

Saravanan_Desingh — Tue, 26 Apr 2016 01:15:30 GMT

Hi sunindia‌,

I have only one dimension and two expressions. I have used stack-style to combine both the expressions.

In your case, I just noticed two dimension.

Re: Bar Chart - Axis Scale

sunny_talwar — Tue, 26 Apr 2016 01:37:30 GMT

Axis fixed with ValueList dimension:

Re: Bar Chart - Axis Scale

Saravanan_Desingh — Tue, 26 Apr 2016 01:55:39 GMT

Yes, Sunny.

This seems to be very close to my requirement. Thanks for your time. I will get back to you.

Re: Bar Chart - Axis Scale

Saravanan_Desingh — Tue, 26 Apr 2016 12:11:35 GMT

Hi sunindia‌

It worked for me Thank you so much for this tip.

Re: Bar Chart - Axis Scale

sunny_talwar — Tue, 26 Apr 2016 12:13:25 GMT

Awesome Saran. I am glad I was able to help you out