topic Re: Is RowNo function skipping first value by default? in QlikView

Is RowNo function skipping first value by default?

jblomqvist — Thu, 13 Aug 2015 19:23:53 GMT

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?

Thu, 13 Aug 2015 19:29:02 GMT

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

sasiparupudi1 — Thu, 13 Aug 2015 19:37:21 GMT

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 — Mon, 17 Aug 2015 06:28:03 GMT

Have you managed to solve your problem?

Sasi

qlikviewwizard — Mon, 17 Aug 2015 07:54:37 GMT

Hi John,

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