Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
sebbyvogel123
New Contributor

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

Re: Fill in missing values

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

Re: Fill in missing values

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

Re: Fill in missing values

maybe helpful:

Generating Missing Data In QlikView

regards

Marco

sebbyvogel123
New Contributor

Re: Fill in missing values

Thank you.

It works great.