topic Re: Grouping in QlikView https://community.qlik.com/t5/QlikView/Grouping/m-p/1104950#M894276 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><P><EM>INPUT:</EM></P><P><EM>LOAD * INLINE [</EM></P><P><EM>PONO, Date</EM></P><P><EM>2, 2/2/2016</EM></P><P><EM>2, 3/3/2016</EM></P><P><EM>3, 3/3/2016</EM></P><P><EM>3, 4/4/2016</EM></P><P><EM>4, 1/1/2016</EM></P><P><EM>5, 1/1/2016</EM></P><P><EM>5, 5/5/2016</EM></P><P><EM>];</EM></P><P><EM> </EM></P><P><EM><STRONG>Result:</STRONG></EM></P><P><STRONG><EM>LOAD PONO, </EM></STRONG></P><P><STRONG><EM>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date, </EM></STRONG></P><P><STRONG><EM>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '</EM></STRONG><STRONG><EM>Month'&amp;AutoNumber(MonthName(Date),PONO) as Month</EM></STRONG></P><P><STRONG><EM>RESIDENT INPUT</EM></STRONG></P><P><EM><STRONG>ORDER BY PONO, Date;</STRONG></EM></P><P></P><P><EM>DROP TABLE INPUT;</EM></P></BODY></HTML> Sun, 14 Aug 2016 18:37:11 GMT swuehl 2016-08-14T18:37:11Z Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/1104947#M894273 <HTML><HEAD></HEAD><BODY><P>i have a table like below</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD class="xl65" height="17" width="113">EMPLOYEE NO</TD><TD class="xl65" style="border-left: none;" width="79">RelationType</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T38</TD><TD class="xl66" style="border-top: none; border-left: none;">Parents</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T38</TD><TD class="xl66" style="border-top: none; border-left: none;">Self</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T46</TD><TD class="xl66" style="border-top: none; border-left: none;">Parents</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T46</TD><TD class="xl66" style="border-top: none; border-left: none;">Self</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T47</TD><TD class="xl66" style="border-top: none; border-left: none;">Parents</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T47</TD><TD class="xl66" style="border-top: none; border-left: none;">Self</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T47</TD><TD class="xl66" style="border-top: none; border-left: none;">Spouse</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T50</TD><TD class="xl66" style="border-top: none; border-left: none;">Parents</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T50</TD><TD class="xl66" style="border-top: none; border-left: none;">Self</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">0T50</TD><TD class="xl66" style="border-top: none; border-left: none;">Spouse</TD></TR></TBODY></TABLE><P></P><P>i want result like below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="17" width="64">EmpNo</TD><TD width="64">ReGroup</TD></TR><TR><TD height="17">0T38</TD><TD>Parents+Self</TD></TR><TR><TD height="17">0T46</TD><TD>Parents+Self</TD></TR><TR><TD height="17">0T47</TD><TD>Parents+Self+Spouse</TD></TR></TBODY></TABLE><P></P><P>is it possible pls help me</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/1104947#M894273 Anonymous 2020-11-25T16:16:04Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/1104948#M894274 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P></P><P></P><P><EM>INPUT:</EM></P><P><EM>LOAD * INLINE [</EM></P><P><EM>EMPLOYEE NO, RelationType</EM></P><P><EM>0T38, Parents</EM></P><P><EM>0T38, Self</EM></P><P><EM>0T46, Parents</EM></P><P><EM>0T46, Self</EM></P><P><EM>0T47, Parents</EM></P><P><EM>0T47, Self</EM></P><P><EM>0T47, Spouse</EM></P><P><EM>0T50, Parents</EM></P><P><EM>0T50, Self</EM></P><P><EM>0T50, Spouse</EM></P><P><EM>];</EM></P><P></P><P><STRONG>Result:</STRONG></P><P><STRONG><EM>LOAD [EMPLOYEE NO], Concat(RelationType, '+') as GroupRelation</EM></STRONG></P><P><STRONG><EM>Resident INPUT</EM></STRONG></P><P><EM><STRONG>GROUP BY [EMPLOYEE NO];</STRONG></EM></P></BODY></HTML> Sun, 14 Aug 2016 16:19:13 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/1104948#M894274 swuehl 2016-08-14T16:19:13Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/1104949#M894275 <HTML><HEAD></HEAD><BODY><P>Thanks Stefan</P><P> One more help</P><P>i have data like below</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="17" width="64">PONO</TD><TD width="64">Date</TD></TR><TR><TD align="right" height="17">2</TD><TD align="right" class="xl63">2/2/2016</TD></TR><TR><TD align="right" height="17">2</TD><TD align="right" class="xl63">3/3/2016</TD></TR><TR><TD align="right" height="17">3</TD><TD align="right" class="xl63">3/3/2016</TD></TR><TR><TD align="right" height="17">3</TD><TD align="right" class="xl63">4/4/2016</TD></TR><TR><TD align="right" height="17">4</TD><TD align="right" class="xl63">1/1/2016</TD></TR><TR><TD align="right" height="17">5</TD><TD align="right" class="xl63">1/1/2016</TD></TR><TR><TD align="right" height="17">5</TD><TD align="right" class="xl63"><P>5/5/2016</P></TD></TR></TBODY></TABLE><P></P><P>i want to get the result like</P><P>&nbsp; </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD height="17" width="64">PONO</TD><TD width="64">Date</TD><TD width="64">Month</TD></TR><TR><TD align="right" height="17">2</TD><TD align="right" class="xl65">2/2/2016</TD><TD>Month1</TD></TR><TR><TD align="right" height="17">2</TD><TD align="right" class="xl65">3/3/2016</TD><TD>Month2</TD></TR><TR><TD align="right" height="17">3</TD><TD align="right" class="xl65">3/3/2016</TD><TD>Month1</TD></TR><TR><TD align="right" height="17">3</TD><TD align="right" class="xl65">4/4/2016</TD><TD>Month2</TD></TR><TR><TD align="right" height="17">4</TD><TD align="right" class="xl65">1/1/2016</TD><TD>Month1</TD></TR><TR><TD align="right" height="17">5</TD><TD align="right" class="xl65">1/1/2016</TD><TD>Month1</TD></TR><TR><TD align="right" height="17">5</TD><TD align="right" class="xl65">5/5/2016</TD><TD>Month2</TD></TR></TBODY></TABLE><P></P><P>pls help me</P></BODY></HTML> Sun, 14 Aug 2016 17:48:51 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/1104949#M894275 Anonymous 2016-08-14T17:48:51Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/1104950#M894276 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><P><EM>INPUT:</EM></P><P><EM>LOAD * INLINE [</EM></P><P><EM>PONO, Date</EM></P><P><EM>2, 2/2/2016</EM></P><P><EM>2, 3/3/2016</EM></P><P><EM>3, 3/3/2016</EM></P><P><EM>3, 4/4/2016</EM></P><P><EM>4, 1/1/2016</EM></P><P><EM>5, 1/1/2016</EM></P><P><EM>5, 5/5/2016</EM></P><P><EM>];</EM></P><P><EM> </EM></P><P><EM><STRONG>Result:</STRONG></EM></P><P><STRONG><EM>LOAD PONO, </EM></STRONG></P><P><STRONG><EM>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date, </EM></STRONG></P><P><STRONG><EM>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '</EM></STRONG><STRONG><EM>Month'&amp;AutoNumber(MonthName(Date),PONO) as Month</EM></STRONG></P><P><STRONG><EM>RESIDENT INPUT</EM></STRONG></P><P><EM><STRONG>ORDER BY PONO, Date;</STRONG></EM></P><P></P><P><EM>DROP TABLE INPUT;</EM></P></BODY></HTML> Sun, 14 Aug 2016 18:37:11 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/1104950#M894276 swuehl 2016-08-14T18:37:11Z