topic Re: how do i arrange feilds according to the given data in QlikView https://community.qlik.com/t5/QlikView/how-do-i-arrange-feilds-according-to-the-given-data/m-p/947082#M964831 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>Region,&nbsp;&nbsp;&nbsp;&nbsp; SubRegion,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data</STRONG></P><P><STRONG>R1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</STRONG></P><P><STRONG>R1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</STRONG></P><P><STRONG>R1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</STRONG></P><P><STRONG>R2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</STRONG></P><P><STRONG>R3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB5,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</STRONG></P><P><STRONG>R4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB6,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</STRONG></P><P><STRONG>R4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB7,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</STRONG></P><P><STRONG>R5,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB8,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>Concatenate(Table)</STRONG></P><P><STRONG>LOAD Region as SubRegion,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Data) as Data</STRONG></P><P><STRONG>Resident Table</STRONG></P><P><STRONG>Group By Region;</STRONG></P><DIV> </DIV></BODY></HTML> Fri, 09 Oct 2015 19:08:57 GMT sunny_talwar 2015-10-09T19:08:57Z how do i arrange feilds according to the given data https://community.qlik.com/t5/QlikView/how-do-i-arrange-feilds-according-to-the-given-data/m-p/947080#M964829 <HTML><HEAD></HEAD><BODY><P>table1</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="201"><TBODY><TR><TD height="20" width="64">Region</TD><TD width="73">SubRegion</TD><TD width="64">Data</TD></TR><TR><TD height="20">R1</TD><TD>SB1</TD><TD align="right">1</TD></TR><TR><TD height="20">R1</TD><TD>SB2</TD><TD align="right">5</TD></TR><TR><TD height="20">R1</TD><TD>SB3</TD><TD align="right">7</TD></TR><TR><TD height="20">R2</TD><TD>SB4</TD><TD align="right">9</TD></TR><TR><TD height="20">R3</TD><TD>SB5</TD><TD align="right">10</TD></TR><TR><TD height="20">R4</TD><TD>SB6</TD><TD align="right">7</TD></TR><TR><TD height="20">R4</TD><TD>SB7</TD><TD align="right">8</TD></TR><TR><TD height="20">R5</TD><TD>SB8</TD><TD align="right">9</TD></TR></TBODY></TABLE><P></P><P>OUTPUT</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="20" width="64">SB1</TD><TD align="right" width="64">1</TD></TR><TR><TD height="20">SB2</TD><TD align="right">5</TD></TR><TR><TD height="20">SB3</TD><TD align="right">7</TD></TR><TR><TD height="20">R1</TD><TD align="right">13</TD></TR><TR><TD height="20">SB4</TD><TD align="right">9</TD></TR><TR><TD height="20">R2</TD><TD align="right">9</TD></TR><TR><TD height="20">SB5</TD><TD align="right">10</TD></TR><TR><TD height="20">R3</TD><TD align="right">10</TD></TR></TBODY></TABLE><P></P><P></P><P>HOW WILL I GET THE DESIRED OUTPUT</P></BODY></HTML> Fri, 09 Oct 2015 11:50:47 GMT https://community.qlik.com/t5/QlikView/how-do-i-arrange-feilds-according-to-the-given-data/m-p/947080#M964829 saniyask 2015-10-09T11:50:47Z Re: how do i arrange feilds according to the given data https://community.qlik.com/t5/QlikView/how-do-i-arrange-feilds-according-to-the-given-data/m-p/947081#M964830 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Fri, 09 Oct 2015 17:23:56 GMT https://community.qlik.com/t5/QlikView/how-do-i-arrange-feilds-according-to-the-given-data/m-p/947081#M964830 Gysbert_Wassenaar 2015-10-09T17:23:56Z Re: how do i arrange feilds according to the given data https://community.qlik.com/t5/QlikView/how-do-i-arrange-feilds-according-to-the-given-data/m-p/947082#M964831 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>Region,&nbsp;&nbsp;&nbsp;&nbsp; SubRegion,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data</STRONG></P><P><STRONG>R1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</STRONG></P><P><STRONG>R1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</STRONG></P><P><STRONG>R1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</STRONG></P><P><STRONG>R2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</STRONG></P><P><STRONG>R3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB5,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</STRONG></P><P><STRONG>R4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB6,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</STRONG></P><P><STRONG>R4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB7,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</STRONG></P><P><STRONG>R5,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SB8,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>Concatenate(Table)</STRONG></P><P><STRONG>LOAD Region as SubRegion,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Data) as Data</STRONG></P><P><STRONG>Resident Table</STRONG></P><P><STRONG>Group By Region;</STRONG></P><DIV> </DIV></BODY></HTML> Fri, 09 Oct 2015 19:08:57 GMT https://community.qlik.com/t5/QlikView/how-do-i-arrange-feilds-according-to-the-given-data/m-p/947082#M964831 sunny_talwar 2015-10-09T19:08:57Z