topic Re: Fill in missing values in QlikView https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11410#M1838 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P>It works great.</P></BODY></HTML> Tue, 27 Feb 2018 09:24:19 GMT sebbyvogel123 2018-02-27T09:24:19Z Fill in missing values https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11407#M1835 <HTML><HEAD></HEAD><BODY><P>Love Community,</P><P></P><P>i have an important conern.</P><P>I need to fill in missing values from the SAP-System.</P><P></P><P>Example:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>%DATUM</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value from SAP</STRONG></TH></TR><TR><TD style="padding: 2px;">01.01.2017</TD><TD style="padding: 2px;">3.000 EUR</TD></TR><TR><TD style="padding: 2px;">01.02.2017</TD><TD style="padding: 2px;">Value in SAP is missing (Value should filled: 3.000 EUR)</TD></TR><TR><TD style="padding: 2px;">01.03.2017</TD><TD style="padding: 2px;">Value in SAP is missing (Value should filled: 3.000 EUR)</TD></TR><TR><TD style="padding: 2px;">01.04.2017</TD><TD style="padding: 2px;">Value in SAP is missing (Value should filled: 3.000 EUR)</TD></TR><TR><TD style="padding: 2px;">01.05.2017</TD><TD style="padding: 2px;">5.505 EUR</TD></TR><TR><TD style="padding: 2px;">01.06.2017</TD><TD style="padding: 2px;">Value in SAP is missing (Value should filled: 5.505 EUR)</TD></TR></TBODY></TABLE><P></P><P></P><P>Is there anyone how can help me?</P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 26 Feb 2018 11:41:28 GMT https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11407#M1835 sebbyvogel123 2018-02-26T11:41:28Z Re: Fill in missing values https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11408#M1836 <HTML><HEAD></HEAD><BODY><P>Hi Sebastian,</P><P></P><P>There are lot of threads related to your question. </P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15196661648571491" jivemacro_uid="_15196661648571491" modifiedtitle="true"> <P>Data:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; %DATUM, Value from SAP</P> <P>&nbsp;&nbsp;&nbsp; 01.01.2017, 3.000 EUR</P> <P>&nbsp;&nbsp;&nbsp; 01.02.2017</P> <P>&nbsp;&nbsp;&nbsp; 01.03.2017</P> <P>&nbsp;&nbsp;&nbsp; 01.04.2017</P> <P>&nbsp;&nbsp;&nbsp; 01.05.2017, 5.505 EUR</P> <P>&nbsp;&nbsp;&nbsp; 01.06.2017</P> <P>];</P> <P></P> <P>NoConcatenate</P> <P>Load %DATUM,</P> <P>If(Len(Trim([Value from SAP]))=0, Peek([Value from SAP]),[Value from SAP]) as [Value from SAP]</P> <P>Resident Data Order by %DATUM;</P> <P>&nbsp;&nbsp;&nbsp; </P> <P>DROP Table Data;</P> </PRE></BODY></HTML> Mon, 26 Feb 2018 17:39:48 GMT https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11408#M1836 tamilarasu 2018-02-26T17:39:48Z Re: Fill in missing values https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11409#M1837 <HTML><HEAD></HEAD><BODY><P>maybe helpful:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 26 Feb 2018 22:27:19 GMT https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11409#M1837 MarcoWedel 2018-02-26T22:27:19Z Re: Fill in missing values https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11410#M1838 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P>It works great.</P></BODY></HTML> Tue, 27 Feb 2018 09:24:19 GMT https://community.qlik.com/t5/QlikView/Fill-in-missing-values/m-p/11410#M1838 sebbyvogel123 2018-02-27T09:24:19Z