Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
omid5ive
Creator II
Creator 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
1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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
petter
Partner - Champion III
Partner - Champion III

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
Creator II
Creator II
Author

Thank you Petter