Auto generate data

[omid5ive]

hi

Ii want to create a table in qlikview with increased number

i want to start it with 1000 and end level is 2000

how can i create it with qlikview automatically

i want something like this:

number
1000
1001
1002
...
...
2000

[petter · Accepted solution]

In a load script - I guess that is what you want:

LOAD

     999 + RecNo() AS number

AUTOGENERATE

     1001;

In your GUI you can make use of a ValueLoop-function to genereate a synthetic unamed field with values (Actually the field is named the same as the entire ValueLoop statement with parameters). This can be used where you can have an expression.

     ValueLoop(1000,2000)    

     Sum( ValueLoop(1000,2000) )

[omid5ive]

Thank you Petter