Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

RecNo()-1 in load script



We are just curious, we are reviewing the if script function article, and we are wondering why the script includes RecNo()-1. we understand why the RecNo() function is included, but not sure why it would give a value of -1? Any help would be appreciated !


SET FirstWeekDay=0; Load Date(MakeDate(2022)+RecNo()-1) as Date Autogenerate 14;

Labels (1)
1 Reply
Specialist III
Specialist III

Hi @ssssssss88888888 , i think is just to start with the first date, because recno() starts in 1, and the script wants to starts adding 0

RecNo - script function

This script functions returns an integer for the number of the currently read row of the current table. The first record is number 1.