Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
omid5ive
Contributor II

Auto generate data

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
Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Auto generate data

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) )

View solution in original post

2 Replies
MVP
MVP

Re: Auto generate data

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) )

View solution in original post

omid5ive
Contributor II

Re: Auto generate data

Thank you Petter