topic Re: Issue in stacked bar chart in QlikView https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970451#M966939 <HTML><HEAD></HEAD><BODY><P>without some sort of application to look at it will be difficult but it looks like on the incorrect image, the size of the bars seem to be correct - by date, they appear to be the total of the other expressions based on the correct example but the stacked is not breaking it out by color</P><P></P><P>does your dimension, customer document cycle, contain the 3 values and your expression is doing a count or sum or avg, etc. or are they 3 different expressions?</P></BODY></HTML> Wed, 30 Sep 2015 13:21:08 GMT 2015-09-30T13:21:08Z Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970448#M966936 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement on stacked bar chart.</P><P>The bar chart looks fine when the sub type is "Grouped" but once I change it to "Stacked" I'm getting very wierd results. Basically two of my expressions don't show up anymore.</P><P>Qlik experts, please guide.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Sachin</P></BODY></HTML> Wed, 30 Sep 2015 13:09:52 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970448#M966936 2015-09-30T13:09:52Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970449#M966937 <HTML><HEAD></HEAD><BODY><P>Difficult to tell. Can you post a dummy app?</P></BODY></HTML> Wed, 30 Sep 2015 13:11:26 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970449#M966937 tseebach 2015-09-30T13:11:26Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970450#M966938 <HTML><HEAD></HEAD><BODY><P>Its difficult to post, its coming from a complex model. But I have added a screen shot though.</P></BODY></HTML> Wed, 30 Sep 2015 13:13:46 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970450#M966938 2015-09-30T13:13:46Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970451#M966939 <HTML><HEAD></HEAD><BODY><P>without some sort of application to look at it will be difficult but it looks like on the incorrect image, the size of the bars seem to be correct - by date, they appear to be the total of the other expressions based on the correct example but the stacked is not breaking it out by color</P><P></P><P>does your dimension, customer document cycle, contain the 3 values and your expression is doing a count or sum or avg, etc. or are they 3 different expressions?</P></BODY></HTML> Wed, 30 Sep 2015 13:21:08 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970451#M966939 2015-09-30T13:21:08Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970452#M966940 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It looks like the bars are stacked as the values on the Y axis have changed, I think that if you tick the option 'Forced 0' under the Axis tab then you might see the other bars stacked at the bottom.</P></BODY></HTML> Wed, 30 Sep 2015 13:23:56 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970452#M966940 cesaraccardi 2015-09-30T13:23:56Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970453#M966941 <HTML><HEAD></HEAD><BODY><P>Woh Cesar. Awesome Sir.. Appreciate all the help</P></BODY></HTML> Wed, 30 Sep 2015 13:26:07 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970453#M966941 2015-09-30T13:26:07Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970454#M966942 <HTML><HEAD></HEAD><BODY><P><BR />Hi Cesar, just a quick question. Is there a way or option to show the sum of all the stacks on top of each bar.</P></BODY></HTML> Wed, 30 Sep 2015 13:46:40 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970454#M966942 2015-09-30T13:46:40Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970455#M966943 <HTML><HEAD></HEAD><BODY><P>you can write an expression that represents the total, do not set as a bar and check value on datapoints - this will display the total above the bar</P></BODY></HTML> Wed, 30 Sep 2015 15:46:43 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970455#M966943 2015-09-30T15:46:43Z Re: Issue in stacked bar chart https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970456#M966944 <HTML><HEAD></HEAD><BODY><P>I used a combo chart instead and made the line invisible. That way just the total ws left out on the top.</P></BODY></HTML> Wed, 30 Sep 2015 18:35:21 GMT https://community.qlik.com/t5/QlikView/Issue-in-stacked-bar-chart/m-p/970456#M966944 2015-09-30T18:35:21Z