Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sebbyvogel123
Contributor II
Contributor II

Fill in missing values

Love Community,

i have an important conern.

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

Example:

%DATUMValue from SAP
01.01.20173.000 EUR
01.02.2017Value in SAP is missing (Value should filled: 3.000 EUR)
01.03.2017Value in SAP is missing (Value should filled: 3.000 EUR)
01.04.2017Value in SAP is missing (Value should filled: 3.000 EUR)
01.05.20175.505 EUR
01.06.2017Value in SAP is missing (Value should filled: 5.505 EUR)

Is there anyone how can help me?

Thanks in advance

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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;

View solution in original post

3 Replies
tamilarasu
Champion
Champion

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
Contributor II
Contributor II
Author

Thank you.

It works great.