topic Re: Bar Graph in QlikView

Bar Graph

Wed, 31 Dec 2014 09:24:23 GMT

Hello,

I have a bar graph like this

I want to separate the bars in groups of 3. How to achieve that? (I want DDP125,DDP126,DDP127 in one group and then DDP128, DDP129, DDP130 in another group.)

Please help.

Thanks

Re: Bar Graph

avinashelite — Wed, 31 Dec 2014 09:41:30 GMT

Hi Arjun,

As per my knowledge its not possible in front end. You need to group it script level but if the dimension had more value then that might also be a problem.

Re: Bar Graph

amit_saini — Wed, 31 Dec 2014 09:45:58 GMT

Hi Arjun,

If you are calling here one dimension and one expression that I don't think so it is possible to divide group based on sequence.

Also check if stacked bar can help you here or not.

Thanks,
AS

Re: Bar Graph

SunilChauhan — Wed, 31 Dec 2014 09:46:01 GMT

I am agrree with Avinash.but if you want distance between Bar

go to chart properties-> presentation-> bar distinace and clutered Distance

increse decrease as per you conveniyance

Re: Bar Graph

udit_kumar_sana — Thu, 01 Jan 2015 16:55:35 GMT

Hi,

Pls find the attached file to try out.

Thanks & Regards,

Udit

Re: Bar Graph

Tue, 06 Jan 2015 09:48:59 GMT

I am agrree with Avinash

Re: Bar Graph

Tue, 06 Jan 2015 09:54:23 GMT

Hi,

add a dimension to it in order to make your groups and add that dimension to the chart...

good luck

Re: Bar Graph

jpenuliar — Tue, 06 Jan 2015 10:01:10 GMT

You can add another field to associate DDPXXXs into their own Group.

You will have 2 dimensions

Dimension1 - Drawer

Dimension2- Drawer Group

See attached.

Re: Bar Graph

jpenuliar — Tue, 06 Jan 2015 10:02:11 GMT