How to get stacked type in a combo chart?

[pipuindia99]

How to get stacked type in a combo chart?

I have two fields, 1. Cluster(group of states), 2. Country. i want country in dimension and cluster in expression in stacked format. and the total should show in line at top. I need help to achieve this.

[Gysbert_Wassenaar]

Add an expression for each cluster with Bar as type.

[pipuindia99]

It looks like hard coding, but i would like to have it dynamically added.

[Digvijay_Singh]

Please share some sample data if possible.

[pipuindia99]

I have attached an example as requested. I need the dashboard similar to the attachment along with the line having total. and Line should not change based on the selection.

[pipuindia99]

Attached sample file

[pipuindia99]

I have attached the file...

[Anil_Babu_Samineni]

Prabhu,

You want to same in Qlikview?

[pipuindia99]

Yes, in addition with a line at top having total and the line should not change based on the cluster group

[Digvijay_Singh]

It looks kind of not possible in Qlikview in direct way caz when we try to plot line chart where individual totals are cluster totals, they cannot be plotted against the overall dimension of the chart which are both cluster group and country.

When I tried to use Aggr by cluster, Qlikview stopped showing me stacked option in style tab. I could achieve the attached one only so far.