Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Fill empty field with previous value.

Hi All,

First one is actual data, the second is the required result.

Actual.bmp Result.bmp

Code:

let Start = floor(makedate(1971,01,01));
let End = floor(today())+1;

let NoOfDays = End - Start;

Cal1:
Load
$(Start)+recno()-1 as Date
autogenerate
$(NoOfDays);


Cal2:
Load
Year(Date) as Year
resident Cal1;

DROP Table Cal1;


A:
LOAD
Year,
Sales
FROM
SNO.xls
(biff, embedded labels, table is Sheet1$);

Final:
Left Join(Cal2)
Load
Year,
Sales,
Year as Year1
resident A;

Drop Table A;

All kind of suggestions/solutions are most welcome.

Thanks

Gangadharan

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: Fill empty field with previous value.

hei

attach is an example

2 Replies
lironbaram
Honored Contributor II

Re: Fill empty field with previous value.

hei

attach is an example

Not applicable

Fill empty field with previous value.

Hi

Thanks a lot... It's working fine.

Community Browser