topic Re: How to group columns?? in QlikView https://community.qlik.com/t5/QlikView/How-to-group-columns/m-p/399928#M1159902 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P>Thanks for the solution.</P><P>You make a Group which contains:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------------</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Planned</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unplanned</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shift</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Work</P><P></P><P>But I want 4 groups like</P><P></P><P>Leave&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Planned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unplanned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shift&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------------</P><P>Planned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Holiday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sick&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S1</P><P>Unplanned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vacation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jury&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bereavement&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S3</P><P>Please help how I get this.???</P></BODY></HTML> Mon, 03 Dec 2012 17:18:37 GMT jsingh71 2012-12-03T17:18:37Z How to group columns?? https://community.qlik.com/t5/QlikView/How-to-group-columns/m-p/399926#M1159900 <HTML><HEAD></HEAD><BODY><P>I have data in following format:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1412px;"><TBODY><TR><TD class="xl63" height="40" width="45">Year</TD><TD class="xl63" style="border-left: medium none;" width="64">Quarter</TD><TD class="xl63" style="border-left: medium none;" width="60">Month</TD><TD class="xl63" style="border-left: medium none;" width="64">Week</TD><TD class="xl64" style="border-left: medium none;" width="89">Schedule Hrs</TD><TD class="xl64" style="border-left: medium none;" width="95">Worked Hours </TD><TD class="xl64" style="border-left: medium none;" width="94">Absent Hours</TD><TD class="xl63" style="border-left: medium none;" width="68">Overtime</TD><TD class="xl64" style="border-left: medium none;" width="64">Planned</TD><TD class="xl64" style="border-left: medium none;" width="53">Holiday</TD><TD class="xl64" style="border-left: medium none;" width="63">Vacation</TD><TD class="xl64" style="border-left: medium none;" width="73">Unplanned</TD><TD class="xl64" style="border-left: medium none;" width="44">Sick</TD><TD class="xl64" style="border-left: medium none;" width="41">Jury</TD><TD class="xl64" style="border-left: medium none;" width="92">Bereavement</TD><TD class="xl63" style="border-left: medium none;" width="99">Plant</TD><TD class="xl64" style="border-left: medium none;" width="104">Department</TD><TD class="xl64" style="border-left: medium none;" width="75">Job</TD><TD class="xl64" style="border-left: medium none;" width="37">S1</TD><TD class="xl64" style="border-left: medium none;" width="45">S2</TD><TD class="xl64" style="border-left: medium none;" width="43">S3</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">2010</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Week 01</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">200</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">190</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">10</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">20</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">6</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">4</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">4</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Flint Assembly</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01023-T-0DIE</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01011-1001</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">4</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">4</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">2010</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Week 02</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">150</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">131</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">19</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">38</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">10</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">3</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">7</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">9</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">5</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Flint Assembly</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01023-T-0DIE</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01011-1001</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">8</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">3</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">8</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">2010</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Week 03</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">175</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">136</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">39</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">76</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">20</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">6</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">14</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">19</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">5</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">7</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">7</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Flint Assembly</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01023-T-0DIE</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01011-1001</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">16</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">11</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">12</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">2010</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Week 04</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">190</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">178</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">12</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">23</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">7</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">5</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">5</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Flint Assembly</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01023-T-0DIE</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">01011-1001</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">6</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">4</TD></TR></TBODY></TABLE><P></P><P>Now I want </P><P> 1) "Planned" and "Unplanned" comes under Leave.&nbsp;&nbsp;&nbsp; for example:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="68" style="width: 143px; height: 43px; border: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Leave</STRONG></SPAN></TH></TR><TR><TD>Planned</TD></TR><TR><TD>Unplanned</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><DIV class="mcePaste" id="_mcePaste" style="left: -10000px; overflow: hidden; width: 1px; position: absolute; top: 337px; height: 1px;"><OBJECT classid="CLSID:A806E1D7-B077-415E-AF08-28AFE10DDF4A" height="304" hspace="0" id="QlikOCX" width="160"><PARAM name="DocName" value="E:\WorkForceAnalytics\Layer2\Model\Model_Prac.qvw" /><PARAM name="ObjectID" value="Document\LB04" /></OBJECT></DIV><P>&nbsp; 2) "Holiday" and "Vacation" comes under "Planned".</P><P>&nbsp; 3) "Sick", "Jury" and "Bereavement" comes under "Unplanned".</P><P>&nbsp; 4)"S1","S2" and "S3" comes under "Shift".</P><P></P><P>How can I achieve this??</P><P>This type of grouping I want in my .qvw file when I create list boxes I want Leave,Planned,Unplanned and Shift Fields.</P></BODY></HTML> Mon, 03 Dec 2012 11:25:30 GMT https://community.qlik.com/t5/QlikView/How-to-group-columns/m-p/399926#M1159900 jsingh71 2012-12-03T11:25:30Z Re: How to group columns?? https://community.qlik.com/t5/QlikView/How-to-group-columns/m-p/399927#M1159901 <HTML><HEAD></HEAD><BODY><P>You'll need to transform your data and create an extra field for the groups. See attached example.</P></BODY></HTML> Mon, 03 Dec 2012 11:56:59 GMT https://community.qlik.com/t5/QlikView/How-to-group-columns/m-p/399927#M1159901 Gysbert_Wassenaar 2012-12-03T11:56:59Z Re: How to group columns?? https://community.qlik.com/t5/QlikView/How-to-group-columns/m-p/399928#M1159902 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P>Thanks for the solution.</P><P>You make a Group which contains:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------------</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Planned</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unplanned</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shift</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Work</P><P></P><P>But I want 4 groups like</P><P></P><P>Leave&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Planned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unplanned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shift&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------------</P><P>Planned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Holiday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sick&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S1</P><P>Unplanned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vacation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jury&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bereavement&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S3</P><P>Please help how I get this.???</P></BODY></HTML> Mon, 03 Dec 2012 17:18:37 GMT https://community.qlik.com/t5/QlikView/How-to-group-columns/m-p/399928#M1159902 jsingh71 2012-12-03T17:18:37Z