Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pipuindia99
Contributor II

How to get stacked type in a combo chart?

How to get stacked type in a combo chart?

 

Ram Issue.png

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.

12 Replies

Re: How to get stacked type in a combo chart?

Add an expression for each cluster with Bar as type.


talk is cheap, supply exceeds demand
pipuindia99
Contributor II

Re: How to get stacked type in a combo chart?

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

Digvijay_Singh
Honored Contributor III

Re: How to get stacked type in a combo chart?

Please share some sample data if possible.

pipuindia99
Contributor II

Re: How to get stacked type in a combo chart?

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
Contributor II

Re: How to get stacked type in a combo chart?

Attached sample file

pipuindia99
Contributor II

Re: How to get stacked type in a combo chart?

I have attached the file...

Re: How to get stacked type in a combo chart?

Prabhu,

You want to same in Qlikview?

Life is so rich, and we need to respect to the life !!!
pipuindia99
Contributor II

Re: How to get stacked type in a combo chart?

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

Digvijay_Singh
Honored Contributor III

Re: How to get stacked type in a combo chart?

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.

Capture.JPG

Community Browser