topic Re: Monthly Comparison in QlikView https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961374#M946689 <HTML><HEAD></HEAD><BODY><P>You can use stacked bar chart like attached.</P></BODY></HTML> Mon, 21 Dec 2015 06:44:54 GMT 2015-12-21T06:44:54Z Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961366#M946681 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have a scenario where I'm trying to determine company headcount in two different ways. </P><P></P><P>Firstly I have created a straight table to sum Headcount by Occupation. Now in order for the Headcount sum to make sense, I have to always have one month selected as I don't want to sum everything but only want to see what was the Headcount in each respective month. I have achieved this by enabling "Always one selected value" for the Month field. </P><P></P><P>Secondly I have created a bar chart&nbsp; to sum total Headcount by Occupation and Month. In this bar chart, I would like to be able to compare multiple months but cannot do that because of enabling&nbsp; <SPAN style="font-size: 13.3333330154419px;">"Always one selected value" to achieve my previous requirement.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">How can I go about achieving both these requirements without affecting each other? Please see attached documents</SPAN></P></BODY></HTML> Mon, 21 Dec 2015 06:25:21 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961366#M946681 2015-12-21T06:25:21Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961367#M946682 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>see attached QVW if it suits your requirement.</P></BODY></HTML> Mon, 21 Dec 2015 06:33:18 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961367#M946682 2015-12-21T06:33:18Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961368#M946683 <HTML><HEAD></HEAD><BODY><P>sorry you want to compare these months ...not show their summations.</P></BODY></HTML> Mon, 21 Dec 2015 06:38:08 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961368#M946683 2015-12-21T06:38:08Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961369#M946684 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I don't prefer using set analysis because I would like this selection to be flexible (able to select one month only, or 2, 3...etc). Set analysis makes it static.</P></BODY></HTML> Mon, 21 Dec 2015 06:39:17 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961369#M946684 2015-12-21T06:39:17Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961370#M946685 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can try this expression..</P><P><STRONG>Sum({&lt;[Headcount Date]=,HeadCountMonth=&gt;}[Head Count])</STRONG></P><P>or </P><P><STRONG>Sum({1}[Head Count])</STRONG></P></BODY></HTML> Mon, 21 Dec 2015 06:39:54 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961370#M946685 settu_periasamy 2015-12-21T06:39:54Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961371#M946686 <HTML><HEAD></HEAD><BODY><P>Yes I would like to compare them in the bar chart</P></BODY></HTML> Mon, 21 Dec 2015 06:40:02 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961371#M946686 2015-12-21T06:40:02Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961372#M946687 <HTML><HEAD></HEAD><BODY><P>Another way woudl be to use alternate states.</P><P>One listbox for straight table and another one for the bar chart.</P><P></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(24 articles)</A></P></BODY></HTML> Mon, 21 Dec 2015 06:42:39 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961372#M946687 robert_mika 2015-12-21T06:42:39Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961373#M946688 <HTML><HEAD></HEAD><BODY><P>Sum({1}[Head Count])</P></BODY></HTML> Mon, 21 Dec 2015 06:42:40 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961373#M946688 PradeepReddy 2015-12-21T06:42:40Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961374#M946689 <HTML><HEAD></HEAD><BODY><P>You can use stacked bar chart like attached.</P></BODY></HTML> Mon, 21 Dec 2015 06:44:54 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961374#M946689 2015-12-21T06:44:54Z Re: Monthly Comparison https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961375#M946690 <HTML><HEAD></HEAD><BODY><P>Hi Robert</P><P></P><P>Thanks! Alternate states will work perfectly.</P></BODY></HTML> Mon, 21 Dec 2015 06:47:53 GMT https://community.qlik.com/t5/QlikView/Monthly-Comparison/m-p/961375#M946690 2015-12-21T06:47:53Z