Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
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_
Partner - Specialist
Partner - Specialist

Hi,

Use

LOAD *

While

construction with autoincremental IterNo() function.

Hope this helps.

Regards,

Andrei Kaliahin