topic Stacked bar chart in QlikView https://community.qlik.com/t5/QlikView/Stacked-bar-chart/m-p/633276#M543278 <HTML><HEAD></HEAD><BODY><P>I have a bar chart which is set to be stacked. However, I don't want it to stack to the sum of the 2 expressions.</P><P>I'm using Total Sales, and then Profit. If I have Total Sales of 10,000 and profit of 3,500, I want to see 2 colors - one which ends at $3,500, and the other which goes from $3,500 to $5,000.</P><P>I know I can change my formula for Total Sales to be sum([Total Sales]-Profit). I don't want to do that, because if someone exports the data to Excel, it will show Total Sales as only $1,500 instead of $5,000.</P><P></P><P>Any ideas on how to accomplish this?</P></BODY></HTML> Wed, 14 May 2014 13:35:36 GMT danielact 2014-05-14T13:35:36Z Stacked bar chart https://community.qlik.com/t5/QlikView/Stacked-bar-chart/m-p/633276#M543278 <HTML><HEAD></HEAD><BODY><P>I have a bar chart which is set to be stacked. However, I don't want it to stack to the sum of the 2 expressions.</P><P>I'm using Total Sales, and then Profit. If I have Total Sales of 10,000 and profit of 3,500, I want to see 2 colors - one which ends at $3,500, and the other which goes from $3,500 to $5,000.</P><P>I know I can change my formula for Total Sales to be sum([Total Sales]-Profit). I don't want to do that, because if someone exports the data to Excel, it will show Total Sales as only $1,500 instead of $5,000.</P><P></P><P>Any ideas on how to accomplish this?</P></BODY></HTML> Wed, 14 May 2014 13:35:36 GMT https://community.qlik.com/t5/QlikView/Stacked-bar-chart/m-p/633276#M543278 danielact 2014-05-14T13:35:36Z