topic interview quetion in QlikView https://community.qlik.com/t5/QlikView/interview-quetion/m-p/853609#M1019099 <HTML><HEAD></HEAD><BODY><P>name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tool</P><P>naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qlikview,tableu</P><P>purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; infruamatica,msbi</P><P></P><P>i want these table like as(split tool)</P><P>naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qlikview</P><P>naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tableu</P><P>purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; infruamatica</P><P>purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msbi</P><P></P><P>for examle</P><P></P><P style="font-size: 13.3333330154419px;">naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qlikview</P><P style="font-size: 13.3333330154419px;">naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tableu</P><P style="font-size: 13.3333330154419px;">purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; infruamatica</P><P style="font-size: 13.3333330154419px;">purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msbi</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">if we use AGGR function for this we can get first table</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">what is the opposite funtion for AGGR</SPAN></P></BODY></HTML> Sat, 04 Apr 2015 08:59:13 GMT 2015-04-04T08:59:13Z interview quetion https://community.qlik.com/t5/QlikView/interview-quetion/m-p/853609#M1019099 <HTML><HEAD></HEAD><BODY><P>name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tool</P><P>naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qlikview,tableu</P><P>purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; infruamatica,msbi</P><P></P><P>i want these table like as(split tool)</P><P>naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qlikview</P><P>naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tableu</P><P>purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; infruamatica</P><P>purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msbi</P><P></P><P>for examle</P><P></P><P style="font-size: 13.3333330154419px;">naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qlikview</P><P style="font-size: 13.3333330154419px;">naveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tableu</P><P style="font-size: 13.3333330154419px;">purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; infruamatica</P><P style="font-size: 13.3333330154419px;">purush&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msbi</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">if we use AGGR function for this we can get first table</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">what is the opposite funtion for AGGR</SPAN></P></BODY></HTML> Sat, 04 Apr 2015 08:59:13 GMT https://community.qlik.com/t5/QlikView/interview-quetion/m-p/853609#M1019099 2015-04-04T08:59:13Z Re: interview quetion https://community.qlik.com/t5/QlikView/interview-quetion/m-p/853610#M1019100 <HTML><HEAD></HEAD><BODY><P>load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; subfield(tool,',') as tool</P><P>from ...</P></BODY></HTML> Sat, 04 Apr 2015 09:18:12 GMT https://community.qlik.com/t5/QlikView/interview-quetion/m-p/853610#M1019100 Gysbert_Wassenaar 2015-04-04T09:18:12Z Re: interview quetion https://community.qlik.com/t5/QlikView/interview-quetion/m-p/853611#M1019101 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P></P><P>Please check the attachment for solution </P></BODY></HTML> Sat, 04 Apr 2015 09:36:07 GMT https://community.qlik.com/t5/QlikView/interview-quetion/m-p/853611#M1019101 Anonymous 2015-04-04T09:36:07Z