topic Re: Replicating the Last field Value in QlikView

Replicating the Last field Value

Tue, 23 Feb 2016 19:51:06 GMT

Hey Community,

I have a two columns in data where one has values till 80 and the other has only 20.

Now I want to replicate the value of 20 in Second column till 80. as below

A B

1 01

. 02

. 03

5 04

10 900

11 901

. .

20 910

. 910

80 910

How can I do that??

Thanks in Advance.

Re: Replicating the Last field Value

vinafidalgo — Tue, 23 Feb 2016 19:56:05 GMT

Can you upload your QVW document?

Re: Replicating the Last field Value

sunny_talwar — Tue, 23 Feb 2016 19:56:59 GMT

So the values between 20 and 80 are missing or null()? and the above provided data is the intended output or input?

Re: Replicating the Last field Value

Tue, 23 Feb 2016 20:01:32 GMT

Hi Sunny,

The values are Null for 21 - 80.

Those values are just as an example...I want replicate the value of 20 for 21 to 80.

Re: Replicating the Last field Value

Tue, 23 Feb 2016 20:02:34 GMT

No, I cant.

Re: Replicating the Last field Value

nagireddy_qv — Tue, 23 Feb 2016 20:30:33 GMT

Hi,

Check this once.

Fill with last non null value during script load

Re: Replicating the Last field Value

Tue, 23 Feb 2016 21:05:19 GMT

I don't think this meets my requirement. May be we can use to replace the Null value.

Can you please post how to replace the null value with my last number 910.

Re: Replicating the Last field Value

MarcoWedel — Tue, 23 Feb 2016 22:11:37 GMT

please post a sample application to demonstrate with.

thanks

regards

Marco

Re: Replicating the Last field Value

Tue, 23 Feb 2016 22:24:45 GMT

Hey Marco,

Please below attached is the sample date. Hope this helps

Re: Replicating the Last field Value

MarcoWedel — Tue, 23 Feb 2016 23:04:36 GMT

Hi,

maybe one solution could be:

given your source:

table1:
LOAD A,
    If(Len(Trim(B)),B,Peek(B)) as B
FROM [https://community.qlik.com/servlet/JiveServlet/download/981305-212759/exp1.xls] (biff, embedded labels, table is Sheet1$);

hope this helps

regards

Marco

Re: Replicating the Last field Value

Thu, 25 Feb 2016 14:43:48 GMT

Thank you very much Marco.

It solved some part of the issue.