Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Autofilling missing values

Need Help!!!

I have data as below:-

i want to fill this column by missing values.

BFU000713
BFU000714
BFU000715
BFU000722
BFU000723
BFU000724

for ex:- thete is difference between BFU000715 and BFU000722 so need to fill it by BFU000716 till BFU000721.

Please find attached for reference

1 Reply
crusader_
Not applicable

Re: Autofilling missing values

Hi,

Use

LOAD *

While

construction with autoincremental IterNo() function.

Hope this helps.

Regards,

Andrei Kaliahin