topic How can I do this? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-do-this/m-p/278027#M1191207 <HTML><HEAD></HEAD><BODY><P>Hi, sorry my bad english, I'm Brazilian.</P><P>Let's go, I have this Table, in .txt file.</P><P></P><P></P><P>|I150|01/02/2009|28/02/2009|</P><P>|I155|110101000011101||218268,15|D|105491,58|116977,08|206782,65|D|</P><P>|I155|110202000011202||133,66|C|127072,87|130021,62|3082,41|C|</P><P>|I155|110203000011203||3570,18|C|793210,21|781406,75|8233,28|D|</P><P>|I155|110205000011205||17001,74|C|168696,26|148043,43|3651,09|D|</P><P>|I155|110206000011206||200,00|D|0,00|0,00|200,00|D|</P><P>|I150|01/03/2009|31/03/2009|</P><P>|I155|110101000011101||206782,65|D|138304,02|128597,78|216488,89|D|</P><P>|I155|110202000011202||3082,41|C|20550,10|18238,70|771,01|C|</P><P>|I155|110203000011203||8233,28|D|786965,59|786851,41|8347,46|D|</P><P>|I155|110205000011205||3651,09|D|93353,39|95642,70|1361,78|D|</P><P></P><P></P><P>And I want do this in qlikView:</P><P></P><P>|01/02/2009|28/02/2009|110101000011101||218268,15|D|105491,58|116977,08|206782,65|D|</P><P>|01/02/2009|28/02/2009|110202000011202||133,66|C|127072,87|130021,62|3082,41|C|</P><P>|01/02/2009|28/02/2009|110203000011203||3570,18|C|793210,21|781406,75|8233,28|D|</P><P>|01/02/2009|28/02/2009|110205000011205||17001,74|C|168696,26|148043,43|3651,09|D|</P><P>|01/02/2009|28/02/2009|110206000011206||200,00|D|0,00|0,00|200,00|D|</P><P>|I150|01/03/2009|31/03/2009|</P><P>|01/03/2009|31/03/2009|110101000011101||206782,65|D|138304,02|128597,78|216488,89|D|</P><P>|01/03/2009|31/03/2009|110202000011202||3082,41|C|20550,10|18238,70|771,01|C|</P><P>|01/03/2009|31/03/2009|110203000011203||8233,28|D|786965,59|786851,41|8347,46|D|</P><P>|01/03/2009|31/03/2009|110205000011205||3651,09|D|93353,39|95642,70|1361,78|D|</P><P></P><P></P><P>I apreciate your replied.....</P><P></P><P>Thank's a lot</P></BODY></HTML> Wed, 13 Jul 2011 15:43:57 GMT 2011-07-13T15:43:57Z How can I do this? https://community.qlik.com/t5/QlikView/How-can-I-do-this/m-p/278027#M1191207 <HTML><HEAD></HEAD><BODY><P>Hi, sorry my bad english, I'm Brazilian.</P><P>Let's go, I have this Table, in .txt file.</P><P></P><P></P><P>|I150|01/02/2009|28/02/2009|</P><P>|I155|110101000011101||218268,15|D|105491,58|116977,08|206782,65|D|</P><P>|I155|110202000011202||133,66|C|127072,87|130021,62|3082,41|C|</P><P>|I155|110203000011203||3570,18|C|793210,21|781406,75|8233,28|D|</P><P>|I155|110205000011205||17001,74|C|168696,26|148043,43|3651,09|D|</P><P>|I155|110206000011206||200,00|D|0,00|0,00|200,00|D|</P><P>|I150|01/03/2009|31/03/2009|</P><P>|I155|110101000011101||206782,65|D|138304,02|128597,78|216488,89|D|</P><P>|I155|110202000011202||3082,41|C|20550,10|18238,70|771,01|C|</P><P>|I155|110203000011203||8233,28|D|786965,59|786851,41|8347,46|D|</P><P>|I155|110205000011205||3651,09|D|93353,39|95642,70|1361,78|D|</P><P></P><P></P><P>And I want do this in qlikView:</P><P></P><P>|01/02/2009|28/02/2009|110101000011101||218268,15|D|105491,58|116977,08|206782,65|D|</P><P>|01/02/2009|28/02/2009|110202000011202||133,66|C|127072,87|130021,62|3082,41|C|</P><P>|01/02/2009|28/02/2009|110203000011203||3570,18|C|793210,21|781406,75|8233,28|D|</P><P>|01/02/2009|28/02/2009|110205000011205||17001,74|C|168696,26|148043,43|3651,09|D|</P><P>|01/02/2009|28/02/2009|110206000011206||200,00|D|0,00|0,00|200,00|D|</P><P>|I150|01/03/2009|31/03/2009|</P><P>|01/03/2009|31/03/2009|110101000011101||206782,65|D|138304,02|128597,78|216488,89|D|</P><P>|01/03/2009|31/03/2009|110202000011202||3082,41|C|20550,10|18238,70|771,01|C|</P><P>|01/03/2009|31/03/2009|110203000011203||8233,28|D|786965,59|786851,41|8347,46|D|</P><P>|01/03/2009|31/03/2009|110205000011205||3651,09|D|93353,39|95642,70|1361,78|D|</P><P></P><P></P><P>I apreciate your replied.....</P><P></P><P>Thank's a lot</P></BODY></HTML> Wed, 13 Jul 2011 15:43:57 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-this/m-p/278027#M1191207 2011-07-13T15:43:57Z