Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

A specific way to present data with a bar chart

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

7 Replies
Highlighted

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

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

Highlighted
Specialist III
Specialist III

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

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

Highlighted
MVP
MVP

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor III
Contributor III

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

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

Highlighted
Contributor III
Contributor III

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

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:

Highlighted
Specialist III
Specialist III

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

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.

Highlighted
Contributor III
Contributor III

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

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.