topic Re: Propagate values in QlikView column in QlikView

Propagate values in QlikView column

Sat, 15 Jun 2013 22:29:33 GMT

Hello fellow QV developers,

Consider the below table:

Test

New Column

Test

I'm asked to propogate values in column Test until there is a non-null value. For example, i would like to see A replicated until there is non-null value and B replicated until there is a non null etc.

Kindly guide me as to how i would write a script for such a requirement.

Cheers.

Thomas

Re: Propagate values in QlikView column

swuehl — Sat, 15 Jun 2013 22:52:54 GMT

Maybe like this:

LOAD

if(len(trim(Test)),Test ,peek(Test) ) as Test

FROM ...;

Re: Propagate values in QlikView column

kumarnatarajan — Sun, 16 Jun 2013 08:29:38 GMT

Hi,

Use below ex. in your script.

Ex:

LOAD if(Len(Trim(Test))=0,Peek(Test),Test) as Test,SNo INLINE [

Test,SNo

A,1

B,4

C,7

];

Find the attached file.

Re: Propagate values in QlikView column

Sun, 16 Jun 2013 12:31:43 GMT

Worked like a charm. Thanks guys