topic Split the total bar in the stacked chart in QlikView https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401180#M798757 <HTML><HEAD></HEAD><BODY><P>I have a stacked chart with two dimensions. I am able to show the stacked chart but having trouble to split the 'Total" bar. Please see the sample attached qlikview file and the screen shot:</P><P>I want the "Total" bar to split into 3000 (Which is the total for Dim2=1) and 2300 <SPAN style="font-size: 13.3333px;">(Which is the total for Dim2=2).</SPAN></P><P></P><P>Thank you for your time.</P><P></P><P><IMG alt="Split-Total_Bar_ScreenShot1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186885_Split-Total_Bar_ScreenShot1.jpg" style="height: 267px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT trdandamudi 2020-11-25T16:16:04Z Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401180#M798757 <HTML><HEAD></HEAD><BODY><P>I have a stacked chart with two dimensions. I am able to show the stacked chart but having trouble to split the 'Total" bar. Please see the sample attached qlikview file and the screen shot:</P><P>I want the "Total" bar to split into 3000 (Which is the total for Dim2=1) and 2300 <SPAN style="font-size: 13.3333px;">(Which is the total for Dim2=2).</SPAN></P><P></P><P>Thank you for your time.</P><P></P><P><IMG alt="Split-Total_Bar_ScreenShot1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186885_Split-Total_Bar_ScreenShot1.jpg" style="height: 267px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401180#M798757 trdandamudi 2020-11-25T16:16:04Z Re: Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401181#M798758 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186879_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Thu, 14 Dec 2017 00:58:51 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401181#M798758 Anil_Babu_Samineni 2017-12-14T00:58:51Z Re: Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401182#M798759 <HTML><HEAD></HEAD><BODY><P>Anil,</P><P>Is it possible to do on the front end with out the island table ? </P></BODY></HTML> Thu, 14 Dec 2017 01:45:47 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401182#M798759 trdandamudi 2017-12-14T01:45:47Z Re: Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401183#M798760 <HTML><HEAD></HEAD><BODY><P>I really hate to do in UI, It kills the performance. I believe we can club using this.</P><P><STRONG>Pick(Match($Field, Dim1), 'Dim1' , 'TOTAL')</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Note - </STRONG>Without hesitate i will say, This will show "<STRONG>out of object</STRONG>" if filter happens and search to all fields and pick only Dim1 to clun TOTAL. That may not a good practice.</P><P></P><P><STRONG style="text-decoration: underline;">Q) Why you didn't like Island Table?</STRONG></P></BODY></HTML> Thu, 14 Dec 2017 02:25:54 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401183#M798760 Anil_Babu_Samineni 2017-12-14T02:25:54Z Re: Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401184#M798761 <HTML><HEAD></HEAD><BODY><P>Agree, Island table is the best but I should not touch the script.</P></BODY></HTML> Thu, 14 Dec 2017 12:44:36 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401184#M798761 trdandamudi 2017-12-14T12:44:36Z Re: Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401185#M798762 <HTML><HEAD></HEAD><BODY><P>Good, Still we can force it.. I got same from customer but i request them to go with Island one only. Let me invite <STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/tresesco">tresesco</A></STRONG> whether he has some inputs to understand better..</P></BODY></HTML> Thu, 14 Dec 2017 12:56:13 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401185#M798762 Anil_Babu_Samineni 2017-12-14T12:56:13Z Re: Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401186#M798763 <HTML><HEAD></HEAD><BODY><P>Alternatively you can use synthetic dimension (using valuelist()/valueloop()). However, that would not be responsive to your selection. Hence the better is what Anil has already suggested.</P><P></P><P>Thanks Anil for the invite.</P></BODY></HTML> Thu, 14 Dec 2017 13:10:11 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401186#M798763 tresB 2017-12-14T13:10:11Z Re: Split the total bar in the stacked chart https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401187#M798764 <HTML><HEAD></HEAD><BODY><P>If you have time, Please made in QVW using ValueList and ValueLoop. I even wonder how this goes..</P></BODY></HTML> Thu, 14 Dec 2017 13:12:45 GMT https://community.qlik.com/t5/QlikView/Split-the-total-bar-in-the-stacked-chart/m-p/1401187#M798764 Anil_Babu_Samineni 2017-12-14T13:12:45Z