topic Re: Two stacked bars with 8 expressions in QlikView https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822895#M290058 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. It worked.</P></BODY></HTML> Fri, 12 Dec 2014 11:35:31 GMT 2014-12-12T11:35:31Z Two stacked bars with 8 expressions https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822891#M290054 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have to create a chart in which there is no dimension but 8 expressions(4 for Activity &amp; 4 for Sales). Now i want these 8 expressions to divided into two stacked bars with 4 expression each(attached image for reference). Is this possible or am i being too ambitious?</P></BODY></HTML> Fri, 12 Dec 2014 09:54:10 GMT https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822891#M290054 2014-12-12T09:54:10Z Re: Two stacked bars with 8 expressions https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822892#M290055 <HTML><HEAD></HEAD><BODY><P>Use a (calculated) dimension for the two bars for Activity and Sales and use four expressions for the bar segments.</P></BODY></HTML> Fri, 12 Dec 2014 09:58:27 GMT https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822892#M290055 Gysbert_Wassenaar 2014-12-12T09:58:27Z Re: Two stacked bars with 8 expressions https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822893#M290056 <HTML><HEAD></HEAD><BODY><P>Actually, I can not create a calculated dimension for Activity &amp; Sales and since the expressions are different, i can not club the dimensions together.</P></BODY></HTML> Fri, 12 Dec 2014 10:02:01 GMT https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822893#M290056 2014-12-12T10:02:01Z Re: Two stacked bars with 8 expressions https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822894#M290057 <HTML><HEAD></HEAD><BODY><P>Of course you can:</P><P></P><P>=valuelist('Activity','Sales')</P><P></P><P>The expression can be changed in:</P><P></P><P>=if(valuelist('Activity','Sales')='Activity', <EM>...activity_expression_PP_here...</EM>, <EM>...sales_expression_PP_here...</EM> )</P></BODY></HTML> Fri, 12 Dec 2014 10:05:05 GMT https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822894#M290057 Gysbert_Wassenaar 2014-12-12T10:05:05Z Re: Two stacked bars with 8 expressions https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822895#M290058 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. It worked.</P></BODY></HTML> Fri, 12 Dec 2014 11:35:31 GMT https://community.qlik.com/t5/QlikView/Two-stacked-bars-with-8-expressions/m-p/822895#M290058 2014-12-12T11:35:31Z