topic Cross reference of a field in QlikView https://community.qlik.com/t5/QlikView/Cross-reference-of-a-field/m-p/951290#M467334 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I hope somebody could help me with a tough Topic. have a loaded Table with Details of Doccode REMIN.</P><P></P><P>The database is in Oracle and the table has all columns for all lines. When Info is not neccessary the field is empty.</P><P>The paydate is in Doclinenum1. The first Line with El1 = '1601' is the Supplier-line with payment-Infos. But I Need to have that payment info the second line with Doclinenum2. The Lines with El1 = '**99' are the asset-accounts. The ref1-6-Fields are References of the Doccode+Docnum (So it is written in every line).</P><P></P><P>SO the Goal is to get a List with all assets bought and with the paydate of These assets.</P><P>How can I realise that? I tried several things but nothing worked, because the second line has its own paydate-field, which is empty.</P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/106210_pastedImage_5.png" /></P><P></P><P></P><P>Thanks in advance.</P><P>Chris</P></BODY></HTML> Fri, 20 Nov 2015 11:35:01 GMT 2015-11-20T11:35:01Z Cross reference of a field https://community.qlik.com/t5/QlikView/Cross-reference-of-a-field/m-p/951290#M467334 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I hope somebody could help me with a tough Topic. have a loaded Table with Details of Doccode REMIN.</P><P></P><P>The database is in Oracle and the table has all columns for all lines. When Info is not neccessary the field is empty.</P><P>The paydate is in Doclinenum1. The first Line with El1 = '1601' is the Supplier-line with payment-Infos. But I Need to have that payment info the second line with Doclinenum2. The Lines with El1 = '**99' are the asset-accounts. The ref1-6-Fields are References of the Doccode+Docnum (So it is written in every line).</P><P></P><P>SO the Goal is to get a List with all assets bought and with the paydate of These assets.</P><P>How can I realise that? I tried several things but nothing worked, because the second line has its own paydate-field, which is empty.</P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/106210_pastedImage_5.png" /></P><P></P><P></P><P>Thanks in advance.</P><P>Chris</P></BODY></HTML> Fri, 20 Nov 2015 11:35:01 GMT https://community.qlik.com/t5/QlikView/Cross-reference-of-a-field/m-p/951290#M467334 2015-11-20T11:35:01Z