topic Re: Help creating a stacked bar chart where each stack has a calculation in QlikView https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018791#M344920 <HTML><HEAD></HEAD><BODY><P>Very probably it's only possible with my suggestion from above by using two charts - one with amounts and one with percentages.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 08 Mar 2016 08:58:32 GMT marcus_sommer 2016-03-08T08:58:32Z Help creating a stacked bar chart where each stack has a calculation https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018787#M344916 <HTML><HEAD></HEAD><BODY><P>I want to create the following chart but i cant quite get it to give the correct results.</P><P></P><P>My fields are:</P><P></P><P>SUPPLIER_ID</P><P>SPEND</P><P>SERVICE_DESC</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117224_Untitled.png" style="height: auto;" /></P></BODY></HTML> Mon, 07 Mar 2016 14:09:56 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018787#M344916 matthewp 2016-03-07T14:09:56Z Re: Help creating a stacked bar chart where each stack has a calculation https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018788#M344917 <HTML><HEAD></HEAD><BODY><P>You could create such chart by using one dimension (your category) and in your case three expressions (top 10, next 10, others) and then choose as design stacked bar. To get both amounts within the bars and percentages on the axis you might need to create two charts which are overlaying eachother and are appropriate layouted (I have tried to adjust this with a dual-function but it didn't worked).</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 07 Mar 2016 15:14:59 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018788#M344917 marcus_sommer 2016-03-07T15:14:59Z Re: Help creating a stacked bar chart where each stack has a calculation https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018789#M344918 <HTML><HEAD></HEAD><BODY><P>You can do something like below</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117237_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>I have create this using dummy data. You can change the expression accordingly</P></BODY></HTML> Mon, 07 Mar 2016 16:17:52 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018789#M344918 Kushal_Chawda 2016-03-07T16:17:52Z Re: Help creating a stacked bar chart where each stack has a calculation https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018790#M344919 <HTML><HEAD></HEAD><BODY><P>is there anyway to get this with&nbsp; the relative percentage on the bottom~?</P><P></P><P>i know it can be done by SUM(Value)/SUM(TOTAL Value) but how can this be displayed on the axis?</P></BODY></HTML> Tue, 08 Mar 2016 08:55:18 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018790#M344919 matthewp 2016-03-08T08:55:18Z Re: Help creating a stacked bar chart where each stack has a calculation https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018791#M344920 <HTML><HEAD></HEAD><BODY><P>Very probably it's only possible with my suggestion from above by using two charts - one with amounts and one with percentages.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 08 Mar 2016 08:58:32 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018791#M344920 marcus_sommer 2016-03-08T08:58:32Z Re: Help creating a stacked bar chart where each stack has a calculation https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018792#M344921 <HTML><HEAD></HEAD><BODY><P>Yes it is possible.. go to chart properties, presentation tab, add text in chart and put the above expression.. now press ctrl and shift to adjust the position of text</P></BODY></HTML> Tue, 08 Mar 2016 09:43:33 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018792#M344921 Kushal_Chawda 2016-03-08T09:43:33Z Re: Help creating a stacked bar chart where each stack has a calculation https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018793#M344922 <HTML><HEAD></HEAD><BODY><P>im having trouble getting this to work as there isnt an even number of suppliers distributed between categories in my data</P><P></P><P>nor is there an equal amount of money spent in&nbsp; each category</P></BODY></HTML> Tue, 08 Mar 2016 09:46:21 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-stacked-bar-chart-where-each-stack-has-a/m-p/1018793#M344922 matthewp 2016-03-08T09:46:21Z