Problem with creating grouped bar chart

[Anonymous]

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.

[settu_periasamy]

Hi,

May be Like this?

[jagan]

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.

[Anonymous]

Hi Settu and Jagan,

Thanks for your reply,

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

[settu_periasamy]

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

Sample attached..

[Anonymous]

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.

[settu_periasamy]

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..

[avinashelite]

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

[HirisH_V7]

Hi,

Check this,

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

PFA,

HTH,

Hirish