Discussion Board for collaboration related to QlikView App Development.
Is this possible to load 1 t0 100 without Recno() or Autogenerate
I know we can do with... Load RecNo( ) as A autogenerate(100);
i=1;for i= 1 to 100;load i as ID;next i
You can do it just as you described, but you sill need a data source -- which can be the AUTOGENERATE keyword.
for i= 1 to 100;
load $(i) as ID autogenerate 1;
View solution in original post
Can you use:
FROM ... ;
do you mean like
FIRST 100, will only load the first 100 rows from the source data
So still we need to use autogenrate!
I am thinking some thing similar in VB.