topic Re: How to use peek/previous logic to this data? in QlikView

How to use peek/previous logic to this data?

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,How to use peek/previous logic to this data?

Thanks in advance.

My source Data:

Requirement to show:

Anil_Babu_Samineni — Wed, 19 Jul 2017 10:15:37 GMT

Please share excel file

effinty2112 — Wed, 19 Jul 2017 10:21:26 GMT

Hi Aretha,

Try:

NoConcatenate

Data1:

load

Row,

Month,

if(IsNull(Month), Peek(Month1),Month) as Month1,

ID,

Description

Resident Data;

DROP Table Data;

You can drop Month and maybe rename Month1.

cheers

Andrew

sunny_talwar — Wed, 19 Jul 2017 11:18:55 GMT

Another script, similar to Andrew

Data:

LOAD RowNo() as Row,

If(Len(Trim(Month)) = 0, Peek('New_Month'), Month) as New_Month,

ID,

Description

FROM

[Sample Data.xlsx]

(ooxml, embedded labels, table is Data);