topic Re: A specific way to present data with a bar chart in QlikView

A specific way to present data with a bar chart

bilalgunay — Tue, 28 Aug 2018 08:56:32 GMT

Hello everyone,

below you see a bar chart to represent a key figure with yearmonth as dimension. I also have the bars seperated with colors for different countries (kind of 2nd dimension)

Does this possible directly, I could not see such selection as a style. Or in Qlik, this would be only possible with extentions? If yes to first question, could you outline the steps I should take?

After successful implementation of this I want to have the 2nd dimension (country for now) as a cyclic Group which would go more deeper with Plants and then Storages etc. (cyclic group is there already if it would be possible to have as 2nd dimension)

Appreciate the help and answers,

Bilal

Re: A specific way to present data with a bar chart

Anonymous — Tue, 28 Aug 2018 09:34:34 GMT

Hi Bilal,

First select two fields as Dimensions then go to style and check Stacked as Subtype.

Create a Cyclic Group and in the place of second dimension mention the Cyclic Group name it will work.

PFA sample

Regards

Ritesh

Re: A specific way to present data with a bar chart

Or — Tue, 28 Aug 2018 09:59:56 GMT

This looks like a standard bar chart with two dimensions and one expression. Are you having any sort of particular problem getting it done?

Re: A specific way to present data with a bar chart

jonathandienst — Tue, 28 Aug 2018 10:48:32 GMT

>> After successful implementation of this I want to have the 2nd dimension (country for now) as a cyclic Group which would go more deeper with Plants and then Storages etc. (cyclic group is there already if it would be possible to have as 2nd dimension)

You should go with a drill--down group instead of a cyclic in this case.

Re: A specific way to present data with a bar chart

bilalgunay — Tue, 28 Aug 2018 13:21:31 GMT

Yes now that I tried and saw, I think it can be even a better option.

Re: A specific way to present data with a bar chart

bilalgunay — Tue, 28 Aug 2018 13:28:09 GMT

First of all, it was my mistake to not use the "stacked" option for standard bar chart.

Yes with two dimensions (even when one was a cyclic or drill down group) and an expression I had the result, that I was expecting.

Could you tell me if it works with Combo Charts too? I tried now and seems like it does not. I mean having 2 dimensions and 2 expressions where 1 expression is a Bar and other is a Line. Stacked Bar Chart option did not do what I was expecting when I had 2 expressions.

Example below:

Re: A specific way to present data with a bar chart

Or — Tue, 28 Aug 2018 14:08:24 GMT

I haven't tried something like that, but intuitively I wouldn't expect it to work. When you have multiple expressions, you need to use your legend for expressions, meaning you can't also use it for dimensions. This would also prevent you from having a stacked bar, I think.

Insofar as Cyclic vs. Drill - use drill if you always want to view the lower dimension (Plant) to only show one higher dimension (country) at a time. If you want to e.g. compare German plants to Italian plants, you'll have to use cyclic groups. I personally have a strong preference for cyclic groups because the drill behavior (which always requires a single member selected from the higher dimension) is counter-productive in most use cases.

Re: A specific way to present data with a bar chart

bilalgunay — Tue, 28 Aug 2018 15:11:55 GMT

Hmm, I see your points. Thanks for the constructive answer Or Shoham.

I will also keep the difference in mind when it comes to cyclic vs drill.