topic Grouping in bar chart in QlikView

Grouping in bar chart

Mon, 23 Mar 2015 13:56:47 GMT

Hi Guys,

I am stuck here...Please help me with the below mentioned query.

I have a table

Country	Type	Points
Mumbai	A	24.0
Mumbai	B	16.6
Mumbai	C	18.1
Mumbai	D	26.8
Mumbai	E	34.7
Mumbai	F	21.4

New york	A	25.3
New york	B	23.8
New york	C	29.0
New york	D
New york	E	42.1
New york	F	25.7

So i need to create a bar chart which should look like this

I have following challenges:

1. I need the bars to be in group, i.e first mumbai and new york, which is possible, but i am getting all in different color bars identified by the types.

2. Between the two group sets of bars, i need a space in between, which i got here as this is taken from excel.

3. By any chance can i make a flip option, where i can select only mumbai or new york and its data should appear.

Thanks in advance!

Regards,

Kuldeep

Re: Grouping in bar chart

Mon, 23 Mar 2015 13:58:40 GMT

Re: Grouping in bar chart

awhitfield — Mon, 23 Mar 2015 14:27:58 GMT

Hi Kuldeep,

see the attached example

Andy

Re: Grouping in bar chart

Mon, 23 Mar 2015 14:35:57 GMT

see attached

Re: Grouping in bar chart

Mon, 23 Mar 2015 14:46:52 GMT

Friends,

Cant see the attachments

Re: Grouping in bar chart

Mon, 23 Mar 2015 14:48:28 GMT

Are you using personal edition or a full license of QV?

Re: Grouping in bar chart

Mon, 23 Mar 2015 15:08:48 GMT

Full licensed version

Re: Grouping in bar chart

ashwanin — Mon, 23 Mar 2015 15:12:13 GMT

I think you are opening this thread from inbox or notification.

Click on the Subject : Grouping in bar chart and then check, if you are not able to see the attachment. Because attachment is there.

Re: Grouping in bar chart

Mon, 23 Mar 2015 15:30:35 GMT

Oh yes, i am sorry folks..will check and get back to you...Thanks!

Re: Grouping in bar chart

Mon, 23 Mar 2015 16:51:32 GMT

Hello Kuldeep,

You can do the following way. You can use Alerts for Text/Button objects.basedon the button selection you can show the Expressions on Chart layout.usethe conditions on Expressions.

I hope this idea will help you.

Let me know if you need any help.

Thanks

San

Re: Grouping in bar chart

Tue, 24 Mar 2015 12:31:51 GMT

Thanks Andrew i got it now. Thanks for your help.

Just one small question, i wanted to ask you, can i change the size of labels i.e.A,B,C,D,E,F in the chart?

Regards,

Kuldeep

Re: Grouping in bar chart

Tue, 24 Mar 2015 12:32:33 GMT

Thanks all.

Your suggestions and solutions were very helpful to me.

Regards,

Kuldeep

Re: Grouping in bar chart

awhitfield — Tue, 24 Mar 2015 12:40:44 GMT

No Problem, use the Settings on the dimension Axis, on the Axes tab, font etc,,

Andy

Re: Grouping in bar chart

Tue, 24 Mar 2015 13:04:45 GMT

Please check this QV file

Re: Grouping in bar chart

Tue, 24 Mar 2015 14:01:53 GMT

Thanks Navven