Discussion Board for collaboration on QlikView Scripting.
I have the following table:
Num($(vMin)+ RowNo()-1) as Numbers1
$(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?
RowNo() always starts at 1. If you dont write -1 your min numbers will be died.
slight change to your script..
RowNo() starts from 1
Have you managed to solve your problem?
Please close the thread if you got the solution. Thank you.