topic How to represent stacked bar with single expression in QlikView https://community.qlik.com/t5/QlikView/How-to-represent-stacked-bar-with-single-expression/m-p/213245#M67025 <HTML><HEAD></HEAD><BODY><P>If you have 2 dimensions with one expression you can change the bar chart to stacked in the Style tab otherwise if you have 1 dimension and 1 expression instead of the bar chart make a block chart.</P><P>Regards.</P></BODY></HTML> Sat, 04 Dec 2010 17:32:05 GMT pover 2010-12-04T17:32:05Z How to represent stacked bar with single expression https://community.qlik.com/t5/QlikView/How-to-represent-stacked-bar-with-single-expression/m-p/213244#M67024 <HTML><HEAD></HEAD><BODY><P>How to represent stacked bar with single expression</P></BODY></HTML> Sat, 04 Dec 2010 08:32:37 GMT https://community.qlik.com/t5/QlikView/How-to-represent-stacked-bar-with-single-expression/m-p/213244#M67024 2010-12-04T08:32:37Z How to represent stacked bar with single expression https://community.qlik.com/t5/QlikView/How-to-represent-stacked-bar-with-single-expression/m-p/213245#M67025 <HTML><HEAD></HEAD><BODY><P>If you have 2 dimensions with one expression you can change the bar chart to stacked in the Style tab otherwise if you have 1 dimension and 1 expression instead of the bar chart make a block chart.</P><P>Regards.</P></BODY></HTML> Sat, 04 Dec 2010 17:32:05 GMT https://community.qlik.com/t5/QlikView/How-to-represent-stacked-bar-with-single-expression/m-p/213245#M67025 pover 2010-12-04T17:32:05Z Re: How to represent stacked bar with single expression https://community.qlik.com/t5/QlikView/How-to-represent-stacked-bar-with-single-expression/m-p/213246#M67026 <HTML><HEAD></HEAD><BODY><P>If you're going for a single-dimension, single-expression chart, you can easily make a stacked single bar chart.</P><P></P><P>Just create a new Calculated Dimension and set the dimension formula to:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code">='' <BR /></PRE><P></P><P>Then promote that new "dummy" dimension to the top of the dimensions list, above your real dimension. </P><P></P><P>Qlikview will be tricked into thinking you have two dimensions and will output a nice, single stacked bar chart. Enjoy!</P></BODY></HTML> Fri, 18 May 2012 09:12:57 GMT https://community.qlik.com/t5/QlikView/How-to-represent-stacked-bar-with-single-expression/m-p/213246#M67026 2012-05-18T09:12:57Z