topic need some help with this interrecord stuff in QlikView https://community.qlik.com/t5/QlikView/need-some-help-with-this-interrecord-stuff/m-p/199691#M58523 <HTML><HEAD></HEAD><BODY><P>Solved it myself ...</P><P>I first select all relevant info from the table ... for both U and A ... so the rows which are garbage are thrown away.</P><P>After this I order the table descending and with the previous function I'm looking if the previous field is an 'A' field ... if so the data is combined.</P><P>The next step is to remove the 'A' from the list, so only the combined rows are left over.</P><P></P><P>Took me a while ... but happy with the result ...</P><P></P></BODY></HTML> Thu, 16 Sep 2010 15:25:42 GMT Anonymous 2010-09-16T15:25:42Z need some help with this interrecord stuff https://community.qlik.com/t5/QlikView/need-some-help-with-this-interrecord-stuff/m-p/199690#M58522 <HTML><HEAD></HEAD><BODY><P>I have a table with logging looking like below ...</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2354_sourceID:2354" /></P><P>The Upgrade lines having an empty before should be taken as 'Upgrade', and the first Active following the upgrade should be taken as 'Active' and these two should be combines like the result below:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2355_sourceID:2355" /></P><P>I'm not really familiar with all the interrecord kind of things, but I assume I need to use something like that to get the result above.</P><P>Anyone has suggestions how to start?</P><P></P><P>thx in advance,</P><P></P><P>Anita</P></BODY></HTML> Tue, 14 Sep 2010 09:57:37 GMT https://community.qlik.com/t5/QlikView/need-some-help-with-this-interrecord-stuff/m-p/199690#M58522 Anonymous 2010-09-14T09:57:37Z need some help with this interrecord stuff https://community.qlik.com/t5/QlikView/need-some-help-with-this-interrecord-stuff/m-p/199691#M58523 <HTML><HEAD></HEAD><BODY><P>Solved it myself ...</P><P>I first select all relevant info from the table ... for both U and A ... so the rows which are garbage are thrown away.</P><P>After this I order the table descending and with the previous function I'm looking if the previous field is an 'A' field ... if so the data is combined.</P><P>The next step is to remove the 'A' from the list, so only the combined rows are left over.</P><P></P><P>Took me a while ... but happy with the result ...</P><P></P></BODY></HTML> Thu, 16 Sep 2010 15:25:42 GMT https://community.qlik.com/t5/QlikView/need-some-help-with-this-interrecord-stuff/m-p/199691#M58523 Anonymous 2010-09-16T15:25:42Z