topic Re: Bar Chart Req. in QlikView

Bar Chart Req.

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

Hi All,

I have a bar chart like below:

I need 3 things.

1. Legend should be under X axis.

2. The Value of Y axis should be like 4M,2M instead of 400,000,000.

3. The percentages share should be on Bar.

Please help.

Thanks,

Sarif

Re: Bar Chart Req.

Anil_Babu_Samineni — Tue, 28 Feb 2017 11:49:51 GMT

1) You should drag and drop where you want

2) The Y axis is associated with one expression - usually (but not necessarily) the first. Did you change the number format for the expression associated with the axis?

May be try something like -- (Sum(Sales) / 10000000) & 'K'

3) Check relative and put the value on data points so that you can get it

Re: Bar Chart Req.

hector_munoz — Tue, 28 Feb 2017 11:56:26 GMT

Hi Mohammad,

I attach a sample with the following:

1. Legend should be under X axis. Select the graph and press CTRL + MAY and move the legend to the bottom place

2. The Value of Y axis should be like 4M,2M instead of 400,000,000. Go to Properties > Number in graph and put e.g. "M€" in 'Thousand Symbol' place

3. The percentages share should be on Bar. Use a dual function in the expression

Regards,
H

Re: Bar Chart Req.

mhmmd_srf — Tue, 28 Feb 2017 11:59:34 GMT

Hello Anil sir,

1. Drag and drop is not happening. Do we need to go any specific tab of property?

3. I did not get this.

Please help.

Thanks,

Sarif

Re: Bar Chart Req.

hector_munoz — Tue, 28 Feb 2017 12:00:03 GMT

Excuse me... When I put "M€" in 'Thousand Symbol' place I lost percentage in bars... I have changed it:

Dividing by 1000 the second parameter of dual function (so the Y axis is in thousands)
Putting "M€" in 'Symbol' instead of 'Thousand Symbol'.

I attach it again...

Regards,

Re: Bar Chart Req.

Anil_Babu_Samineni — Tue, 28 Feb 2017 12:03:39 GMT

No need to call Sir, my name is Anil

Coming to

1) here, Mouse over on Legend and use Ctrl + Long key. Then drag to the bottom of that legend. Then you will get it

3) May be understand is not suit. Can you describe more / Provide application so that we came to know as you want

Re: Bar Chart Req.

mhmmd_srf — Tue, 28 Feb 2017 13:15:32 GMT

Hello Sir,

I used your expression. And if I Check Values on data points, it is showing the million value, not percentage values.

How to make this.

Please help.

Thanks,

Sarif

Re: Bar Chart Req.

hector_munoz — Tue, 28 Feb 2017 13:29:55 GMT

Hi Sarif,

I donot understand; in this expression:

Dual(Num(Sum(Sales) / Sum(TOTAL <Year> Sales), '#.##0%'), Sum(Sales) / 1000)

First parameter of Dual() function: Num(Sum(Sales) / Sum(TOTAL <Year> Sales), '#.##0%'), is the value shown, and
Second parameter: Sum(Sales) / 1000, is the value represented in the garph (columns and blocks lenght).

Besides you have to activate something like 'Place values on segments' option (next picture is in spanish):

Can you fix it with this indications?

Regards,

Re: Bar Chart Req.

mhmmd_srf — Wed, 01 Mar 2017 06:21:57 GMT

Thanks a lot sir...it worked..

But I blindly copied that...did not understand..

Could you please explain me this...so that in future I can do with out any help..

Thanks,

Sarif

Re: Bar Chart Req.

Anil_Babu_Samineni — Wed, 01 Mar 2017 06:35:02 GMT

He explained already with each of expression. Here you go

Do you mean picture in English? That highlighted put into the inside of the bar which Qlikview function already setup with Code

Re: Bar Chart Req.

hector_munoz — Wed, 01 Mar 2017 08:07:29 GMT

Anil,

Consider that you need 2 different "things" with a unique expression in your chart:

A column and blocks length in Y axis, and
A percentage measure inside each block

We use Dual() function as it allows to represent one metric (Sales) and have the values of another (Share)

Regards,