topic Filling in missing values QV-SAP in QlikView https://community.qlik.com/t5/QlikView/Filling-in-missing-values-QV-SAP/m-p/476648#M1140230 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have this kind of table (with millions of Documents): </P><P>I need to fille the missing data in with vendors/customers/offseting GL account (where vendor/customer is not given).</P><P></P><P>For example:</P><P>If there is data about vendor (vendor ID) in one of the line items in a specific document, then it should be filled in all line items in the document. If there is data about customer in one of the line items of a specific document, all line items relevant to that document should be filled with customer ID. If there is no data about the vendor/customer, then it should take offset GL account.</P><P></P><P>I have already tried with peek function and if function, but it is quite complex to put all of these rules into one field.</P><P></P><P><SPAN style="color: #363636;">Is there any smart way to do it? I appreciate the help</SPAN></P><P></P><P></P></BODY></HTML> Wed, 25 Sep 2013 09:54:39 GMT 2013-09-25T09:54:39Z Filling in missing values QV-SAP https://community.qlik.com/t5/QlikView/Filling-in-missing-values-QV-SAP/m-p/476648#M1140230 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have this kind of table (with millions of Documents): </P><P>I need to fille the missing data in with vendors/customers/offseting GL account (where vendor/customer is not given).</P><P></P><P>For example:</P><P>If there is data about vendor (vendor ID) in one of the line items in a specific document, then it should be filled in all line items in the document. If there is data about customer in one of the line items of a specific document, all line items relevant to that document should be filled with customer ID. If there is no data about the vendor/customer, then it should take offset GL account.</P><P></P><P>I have already tried with peek function and if function, but it is quite complex to put all of these rules into one field.</P><P></P><P><SPAN style="color: #363636;">Is there any smart way to do it? I appreciate the help</SPAN></P><P></P><P></P></BODY></HTML> Wed, 25 Sep 2013 09:54:39 GMT https://community.qlik.com/t5/QlikView/Filling-in-missing-values-QV-SAP/m-p/476648#M1140230 2013-09-25T09:54:39Z Re: Filling in missing values QV-SAP https://community.qlik.com/t5/QlikView/Filling-in-missing-values-QV-SAP/m-p/476649#M1140231 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>is there anyone who could help me? Do you need additional info?</P><P></P><P>I appreciate the help,</P><P></P><P>BR</P></BODY></HTML> Fri, 27 Sep 2013 08:01:19 GMT https://community.qlik.com/t5/QlikView/Filling-in-missing-values-QV-SAP/m-p/476649#M1140231 2013-09-27T08:01:19Z