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