topic Re: Stacked chart with total in QlikView https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830352#M470875 <HTML><HEAD></HEAD><BODY><P>Thank so lot. Is it possible to have 100% in every stacked bar?</P></BODY></HTML> Mon, 27 Apr 2015 14:11:02 GMT Anonymous 2015-04-27T14:11:02Z Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830346#M470869 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>there is a problem with a kombi-chart. Three bars should be stacked in percent and Total is one line. First stacked bar have right values in chart. If I add line chart, bars are not stacked? In second chart bars are stacked but I have wrong values.</P><P></P><P>Regards Stefan</P></BODY></HTML> Mon, 27 Apr 2015 10:20:40 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830346#M470869 Anonymous 2015-04-27T10:20:40Z Re: Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830347#M470870 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You cannot use stacked bars in a combochart if you have more than one expression.</P><P></P><P>If you search in the community there are a lot of cases like yours.</P></BODY></HTML> Mon, 27 Apr 2015 10:40:15 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830347#M470870 fvelascog72 2015-04-27T10:40:15Z Re: Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830348#M470871 <HTML><HEAD></HEAD><BODY><P>See attached qvw. Is that more like what you're looking for?</P></BODY></HTML> Mon, 27 Apr 2015 10:42:32 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830348#M470871 Gysbert_Wassenaar 2015-04-27T10:42:32Z Re: Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830349#M470872 <HTML><HEAD></HEAD><BODY><P>Hi, that's exactly what i'm looking for.</P></BODY></HTML> Mon, 27 Apr 2015 11:08:47 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830349#M470872 Anonymous 2015-04-27T11:08:47Z Re: Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830350#M470873 <HTML><HEAD></HEAD><BODY><P>One question again? How can I fixed y-axis to 100%</P></BODY></HTML> Mon, 27 Apr 2015 11:13:54 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830350#M470873 Anonymous 2015-04-27T11:13:54Z Re: Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830351#M470874 <HTML><HEAD></HEAD><BODY><P>On the Axes tab set the Static Max setting to 1 for the expression axes</P></BODY></HTML> Mon, 27 Apr 2015 12:17:04 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830351#M470874 Gysbert_Wassenaar 2015-04-27T12:17:04Z Re: Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830352#M470875 <HTML><HEAD></HEAD><BODY><P>Thank so lot. Is it possible to have 100% in every stacked bar?</P></BODY></HTML> Mon, 27 Apr 2015 14:11:02 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830352#M470875 Anonymous 2015-04-27T14:11:02Z Re: Stacked chart with total https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830353#M470876 <HTML><HEAD></HEAD><BODY><P>Yes, but then the percentages will change. Instead of dividing by <EM>Count(total QP_neu)</EM> divide by <EM>Count(total &lt;dq_mon_FY&gt; QP_neu)</EM></P></BODY></HTML> Mon, 27 Apr 2015 14:49:37 GMT https://community.qlik.com/t5/QlikView/Stacked-chart-with-total/m-p/830353#M470876 Gysbert_Wassenaar 2015-04-27T14:49:37Z