topic How to to club two expressions from a set of four into a pair of stacked bar chart in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772049#M1863 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement to display the following in a bar chart.</P><P>Dimension:</P><P>Month</P><P>Expressions:</P><P>1. Open Tickets</P><P>2. Closed tickets</P><P>3. Open tickets for department A</P><P>4. Closed tickets for department A</P><P></P><P>The bar chart should have two bars " Open ticket and Closed ticket" being displayed for a single dimension "Month" but the bars should be stacked and display 'Open tickets for department A' and 'Closed tickets for department A' in the respective two bars itself.</P><P></P><P>Looking for a solution to this problem. Is it feasible?</P></BODY></HTML> Tue, 10 Mar 2015 05:29:13 GMT 2015-03-10T05:29:13Z How to to club two expressions from a set of four into a pair of stacked bar chart https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772049#M1863 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement to display the following in a bar chart.</P><P>Dimension:</P><P>Month</P><P>Expressions:</P><P>1. Open Tickets</P><P>2. Closed tickets</P><P>3. Open tickets for department A</P><P>4. Closed tickets for department A</P><P></P><P>The bar chart should have two bars " Open ticket and Closed ticket" being displayed for a single dimension "Month" but the bars should be stacked and display 'Open tickets for department A' and 'Closed tickets for department A' in the respective two bars itself.</P><P></P><P>Looking for a solution to this problem. Is it feasible?</P></BODY></HTML> Tue, 10 Mar 2015 05:29:13 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772049#M1863 2015-03-10T05:29:13Z Re: How to to club two expressions from a set of four into a pair of stacked bar chart https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772050#M1864 <HTML><HEAD></HEAD><BODY><P>Could you attached your data/file?</P></BODY></HTML> Tue, 10 Mar 2015 08:28:15 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772050#M1864 robert_mika 2015-03-10T08:28:15Z Re: How to to club two expressions from a set of four into a pair of stacked bar chart https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772051#M1865 <HTML><HEAD></HEAD><BODY><P>Hi Robert,</P><P></P><P>Won't be able to attach the data/qvw but attaching a snapshot of how the bar chart looks for the four expressions. (Snip.jpg)</P><P><IMG alt="Snip.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80323_Snip.JPG" style="height: auto;" /></P><P></P><P></P><P>The data for 'Dept A Open' and 'Dept A Closed' is a subset of the entire data set for 'Open tickets' and 'Closed tickets' respectively.</P><P></P><P>The objective is to try and show the subsets in a pair of bars for the 'Open tickets' and 'Closed tickets' (Snip2.jpg) as a stacked bar chart generally looks like</P><P><IMG alt="Snip 2.JPG" class="jive-image image-2" src="/legacyfs/online/80324_Snip 2.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 10 Mar 2015 09:28:40 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772051#M1865 2015-03-10T09:28:40Z Re: How to to club two expressions from a set of four into a pair of stacked bar chart https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772052#M1866 <HTML><HEAD></HEAD><BODY><P>Hi Bhupesh,</P><P></P><P>please see the attached.</P><P></P><P>Regards</P><P></P><P>Andy</P></BODY></HTML> Tue, 10 Mar 2015 09:55:29 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772052#M1866 awhitfield 2015-03-10T09:55:29Z Re: How to to club two expressions from a set of four into a pair of stacked bar chart https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772053#M1867 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-size: 11pt; mso-hansi-theme-font: minor-latin; font-family: 'Calibri',sans-serif; mso-ascii-theme-font: minor-latin;">Hi Andrew,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-size: 11pt; mso-hansi-theme-font: minor-latin; font-family: 'Calibri',sans-serif; mso-ascii-theme-font: minor-latin;">I had a look at your expressions in the qvw. </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><SPAN style="color: #000000;">The value of </SPAN><SPAN style="color: blue;">Sum</SPAN><SPAN style="color: #000000;">(</SPAN><SPAN style="color: maroon;">DeptAOpen</SPAN><SPAN style="color: #000000;">)&nbsp; and </SPAN><SPAN style="color: blue;">sum</SPAN><SPAN style="color: #000000;">(</SPAN><SPAN style="color: maroon;">DeptAClosed</SPAN><SPAN style="color: #000000;">) <SPAN style="mso-spacerun: yes;"> </SPAN>should be speparately visible in the same two bars of the graph- “All Open” and “All Closed” but with a different colour so that they can be identified.</SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P></BODY></HTML> Tue, 10 Mar 2015 10:03:19 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772053#M1867 2015-03-10T10:03:19Z Re: How to to club two expressions from a set of four into a pair of stacked bar chart https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772054#M1868 <HTML><HEAD></HEAD><BODY><P>You have similar problem with solution here:</P><P><A href="https://community.qlik.com/thread/51080">grouped / stacked bar graph</A></P></BODY></HTML> Tue, 10 Mar 2015 10:17:16 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772054#M1868 robert_mika 2015-03-10T10:17:16Z Re: How to to club two expressions from a set of four into a pair of stacked bar chart https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772055#M1869 <HTML><HEAD></HEAD><BODY><P>Solution found</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/thread/155484">http://community.qlik.com/thread/155484</A></P></BODY></HTML> Wed, 11 Mar 2015 06:12:13 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-to-club-two-expressions-from-a-set-of-four-into-a-pair-of/m-p/772055#M1869 2015-03-11T06:12:13Z