topic Grouping in QlikView https://community.qlik.com/t5/QlikView/Grouping/m-p/466595#M697366 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>please help me to solve this one</P><P></P><P>i have a account code field</P><P>100000000</P><P>200000000</P><P>300000000</P><P>400000000</P><P>500000000</P><P>1211</P><P>1212</P><P>........</P><P>,,,,,,,,,</P><P>2211</P><P>2213</P><P>..............</P><P>..............</P><P>..........</P><P>3213</P><P>3212</P><P>...........</P><P>..............</P><P>4211</P><P>4212</P><P>............</P><P>..............</P><P>521</P><P>5211</P><P></P><P></P><P>the field in which the first five long values should be account header, so i need those five values to brought out in the another field, so that if we put straight table we can have more description, fisrt account header, next respective account no. to account header and categories</P><P>is there any way to do this in script to seperate first five and relate those values&nbsp; with respective account nos</P><P></P><P>please help me</P></BODY></HTML> Mon, 25 Feb 2013 05:23:15 GMT kalyandg 2013-02-25T05:23:15Z Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/466595#M697366 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>please help me to solve this one</P><P></P><P>i have a account code field</P><P>100000000</P><P>200000000</P><P>300000000</P><P>400000000</P><P>500000000</P><P>1211</P><P>1212</P><P>........</P><P>,,,,,,,,,</P><P>2211</P><P>2213</P><P>..............</P><P>..............</P><P>..........</P><P>3213</P><P>3212</P><P>...........</P><P>..............</P><P>4211</P><P>4212</P><P>............</P><P>..............</P><P>521</P><P>5211</P><P></P><P></P><P>the field in which the first five long values should be account header, so i need those five values to brought out in the another field, so that if we put straight table we can have more description, fisrt account header, next respective account no. to account header and categories</P><P>is there any way to do this in script to seperate first five and relate those values&nbsp; with respective account nos</P><P></P><P>please help me</P></BODY></HTML> Mon, 25 Feb 2013 05:23:15 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/466595#M697366 kalyandg 2013-02-25T05:23:15Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/466596#M697367 <HTML><HEAD></HEAD><BODY><P>Where is the relation between your first 5 long account headers and to the data..</P></BODY></HTML> Mon, 25 Feb 2013 05:29:30 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/466596#M697367 phaneendra_kunc 2013-02-25T05:29:30Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/466597#M697368 <HTML><HEAD></HEAD><BODY><P>plz upload your sample data</P></BODY></HTML> Mon, 25 Feb 2013 05:34:01 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/466597#M697368 sushil353 2013-02-25T05:34:01Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/466598#M697369 <HTML><HEAD></HEAD><BODY><P>account code and account name is the relation between these fields</P></BODY></HTML> Mon, 25 Feb 2013 05:34:47 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/466598#M697369 kalyandg 2013-02-25T05:34:47Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/466599#M697370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA</P></BODY></HTML> Mon, 25 Feb 2013 05:38:56 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/466599#M697370 khadeer 2013-02-25T05:38:56Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/466600#M697371 <HTML><HEAD></HEAD><BODY><P>hi susil,</P><P>i have attached my sample doc here</P></BODY></HTML> Mon, 25 Feb 2013 05:48:32 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/466600#M697371 kalyandg 2013-02-25T05:48:32Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/466601#M697372 <HTML><HEAD></HEAD><BODY><P>hi, </P><P></P><P>thanks for ur reply</P><P>but i cant understand what you have given</P></BODY></HTML> Mon, 25 Feb 2013 05:52:08 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/466601#M697372 kalyandg 2013-02-25T05:52:08Z