Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Missing Values

How to fill missing values with the latest populated value (case when the previous value is also missing)?

Eg IF I have table like this

A       B   C           D(to be filled)

a       t     1           1

b       u     2          2

c       v     3          3

d       w    -           3

e       x     -           3

f       y     -            3

g       z    4           4

The data in the column D is to be filled using the column C . How can I do this ?

5 Replies
MVP
MVP

Re: Missing Values

Try like:

Load

          A,B,C,

          If(Len(trim(C))=0, Peek(D), C) as D

From <>:

MVP & Luminary
MVP & Luminary

Re: Missing Values

LOAD

     A,

     B,

     C,

     If(Len(Trim(C)),C, peek(D)) as D

FROM

     ...source...

;


talk is cheap, supply exceeds demand
Not applicable

Re: Missing Values

Sure!  I shall try that.

Thanks for the response

Not applicable

Re: Missing Values

Thanks !

oknotsen
Honored Contributor III

Re: Missing Values

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!