topic Re: Problem with creating grouped bar chart in QlikView

Problem with creating grouped bar chart

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

Hi I have a question,

I want to show a bar chart with 3 dimension (GROUP, BRAND, DESC)

But when i go to Style--> subtype , i can't choose "grouped", and it create stack bar chart by default.

I want to show a chart like this :

I also attach my sample qlikview file and data source.

Really appreciate your help.

Thanks in advance.

Re: Problem with creating grouped bar chart

settu_periasamy — Mon, 07 Mar 2016 02:50:45 GMT

Hi,

May be Like this?

Re: Problem with creating grouped bar chart

jagan — Mon, 07 Mar 2016 03:18:52 GMT

Hi,

If you have third dimension in the bar chart by default it will stack the third dimension, and the options (Stacked & Grouped) are disabled.

Regards,

jagan.

Re: Problem with creating grouped bar chart

Anonymous — Mon, 07 Mar 2016 03:31:22 GMT

Hi Settu and Jagan,

Thanks for your reply,

So it is impossible to create grouped bar chart if i have 3 dimension ?

Re: Problem with creating grouped bar chart

settu_periasamy — Mon, 07 Mar 2016 03:39:17 GMT

May be you can combine two dimension (Group & Brand ) into single and use it in your dimension.

Sample attached..

Re: Problem with creating grouped bar chart

Anonymous — Mon, 07 Mar 2016 03:45:51 GMT

Wow, Great idea Settu.

Thanks for your idea.

Another one question, why in GA and GB Group it shows all brand, actually GA only has Brand A and B, but it show Brand C,D, and E.

Re: Problem with creating grouped bar chart

settu_periasamy — Mon, 07 Mar 2016 04:24:23 GMT

Hi,

This is the expected behaviour in Qv if we use 3 dimension. As suggested in previous thread you can combine those fields into single. It will look like this..

Re: Problem with creating grouped bar chart

avinashelite — Mon, 07 Mar 2016 05:46:06 GMT

did you tried with the combo chart i.e, is the combination of the line and bar chart ??

Re: Problem with creating grouped bar chart

HirisH_V7 — Mon, 07 Mar 2016 06:20:46 GMT

Hi,

Check this,

Is this you require,You can go with combo Chart .

PFA,

HTH,

Hirish