topic How to get stacked type in a combo chart? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139902#M521407 <HTML><HEAD></HEAD><BODY><H1> <A _jive_internal="true" href="https://community.qlik.com/message/1055425#1055425">How to get stacked type in a combo chart?</A> </H1><P></P><H1></H1><P></P><P>&nbsp; </P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1055425-127042/Ram Issue.png"><IMG alt="Ram Issue.png" class="jive-image image-1" height="471" src="/legacyfs/online/127053_Ram Issue.png" width="857" /></A></P><P>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.</P></BODY></HTML> Tue, 07 Jun 2016 10:19:38 GMT pipuindia99 2016-06-07T10:19:38Z How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139902#M521407 <HTML><HEAD></HEAD><BODY><H1> <A _jive_internal="true" href="https://community.qlik.com/message/1055425#1055425">How to get stacked type in a combo chart?</A> </H1><P></P><H1></H1><P></P><P>&nbsp; </P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1055425-127042/Ram Issue.png"><IMG alt="Ram Issue.png" class="jive-image image-1" height="471" src="/legacyfs/online/127053_Ram Issue.png" width="857" /></A></P><P>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.</P></BODY></HTML> Tue, 07 Jun 2016 10:19:38 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139902#M521407 pipuindia99 2016-06-07T10:19:38Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139903#M521408 <HTML><HEAD></HEAD><BODY><P>Add an expression for each cluster with Bar as type.</P></BODY></HTML> Tue, 07 Jun 2016 15:48:33 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139903#M521408 Gysbert_Wassenaar 2016-06-07T15:48:33Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139904#M521409 <HTML><HEAD></HEAD><BODY><P>It looks like hard coding, but i would like to have it dynamically added.</P></BODY></HTML> Wed, 08 Jun 2016 05:26:25 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139904#M521409 pipuindia99 2016-06-08T05:26:25Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139905#M521410 <HTML><HEAD></HEAD><BODY><P>Please share some sample data if possible.</P></BODY></HTML> Wed, 08 Jun 2016 05:37:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139905#M521410 Digvijay_Singh 2016-06-08T05:37:48Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139906#M521411 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 08 Jun 2016 07:42:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139906#M521411 pipuindia99 2016-06-08T07:42:16Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139907#M521412 <HTML><HEAD></HEAD><BODY><P>Attached sample file</P></BODY></HTML> Wed, 08 Jun 2016 07:44:49 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139907#M521412 pipuindia99 2016-06-08T07:44:49Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139908#M521413 <HTML><HEAD></HEAD><BODY><P>I have attached the file...</P></BODY></HTML> Wed, 08 Jun 2016 07:45:15 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139908#M521413 pipuindia99 2016-06-08T07:45:15Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139909#M521414 <HTML><HEAD></HEAD><BODY><P>Prabhu,</P><P></P><P><STRONG>You want to same in Qlikview?</STRONG></P></BODY></HTML> Wed, 08 Jun 2016 08:03:50 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139909#M521414 Anil_Babu_Samineni 2016-06-08T08:03:50Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139910#M521415 <HTML><HEAD></HEAD><BODY><P>Yes, in addition with a line at top having total and the line should not change based on the cluster group</P></BODY></HTML> Wed, 08 Jun 2016 08:56:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139910#M521415 pipuindia99 2016-06-08T08:56:28Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139911#M521416 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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.</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127194_Capture.JPG" style="height: 250px; width: 620px;" /></P></BODY></HTML> Wed, 08 Jun 2016 08:59:35 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139911#M521416 Digvijay_Singh 2016-06-08T08:59:35Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139912#M521417 <HTML><HEAD></HEAD><BODY><P>This one I have already tried, but the requirement is in Stack format. Thanks for sharing this</P></BODY></HTML> Wed, 08 Jun 2016 09:28:22 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139912#M521417 pipuindia99 2016-06-08T09:28:22Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139913#M521418 <HTML><HEAD></HEAD><BODY><P>Prabhu,</P><P></P><P>as per my suggestion. Expression must be on Group..</P><P></P><P><STRONG>Please create group for those two expressions and let me know if there is any changes...</STRONG></P></BODY></HTML> Wed, 08 Jun 2016 09:31:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139913#M521418 Anil_Babu_Samineni 2016-06-08T09:31:14Z Re: How to get stacked type in a combo chart? https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139914#M521419 <HTML><HEAD></HEAD><BODY><P>If we group it will be stacked but i need the line to be on top. now if we group the line will be missing</P></BODY></HTML> Wed, 08 Jun 2016 10:21:15 GMT https://community.qlik.com/t5/QlikView/How-to-get-stacked-type-in-a-combo-chart/m-p/1139914#M521419 pipuindia99 2016-06-08T10:21:15Z