Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Is RowNo function skipping first value by default?

Hi all,

I have the following table:

FullTable:

LOAD

    Num($(vMin)+ RowNo()-1) as Numbers1

AutoGenerate

    $(vMax) - $(vMin)+1;

This table generates all possible numbers from 1 to 100.

I've noticed that if I don't insert a -1 after RowNo() function above it starts from number 2.

And I have to do a +1 in order to get the last value.

Is it because RowNo() is by default gives you the next row rather than the first row value?

4 Replies
Not applicable

RowNo() always starts at 1. If you dont write -1 your min numbers will be died.

sasiparupudi1
Master III
Master III

slight change to your script..

RowNo() starts from 1

set vMin=0;
set vMax=100;

FullTable:

LOAD

Num($(vMin)+ RowNo()) as Numbers1

AutoGenerate

$(vMax) -$(vMin)+RowNo();

sasiparupudi1
Master III
Master III

Hi

Have you managed to solve your problem?

Sasi

qlikviewwizard
Master II
Master II

Hi John,

Please close the thread if you got the solution. Thank you.