Fill in missing values

[sebbyvogel123]

Love Community,

i have an important conern.

I need to fill in missing values from the SAP-System.

Example:

%DATUM	Value from SAP
01.01.2017	3.000 EUR
01.02.2017	Value in SAP is missing (Value should filled: 3.000 EUR)
01.03.2017	Value in SAP is missing (Value should filled: 3.000 EUR)
01.04.2017	Value in SAP is missing (Value should filled: 3.000 EUR)
01.05.2017	5.505 EUR
01.06.2017	Value in SAP is missing (Value should filled: 5.505 EUR)

Is there anyone how can help me?

Thanks in advance

[tamilarasu · Accepted solution]

Hi Sebastian,

There are lot of threads related to your question.

Data:
LOAD * INLINE [
    %DATUM, Value from SAP
    01.01.2017, 3.000 EUR
    01.02.2017
    01.03.2017
    01.04.2017
    01.05.2017, 5.505 EUR
    01.06.2017
];

NoConcatenate
Load %DATUM,
If(Len(Trim([Value from SAP]))=0, Peek([Value from SAP]),[Value from SAP]) as [Value from SAP]
Resident Data Order by %DATUM;

DROP Table Data;

[MarcoWedel]

maybe helpful:

Generating Missing Data In QlikView

regards

Marco

[sebbyvogel123]

Thank you.

It works great.