topic Re: Auto generate data in QlikView

Auto generate data

omid5ive — Sun, 11 Oct 2015 06:29:39 GMT

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

Re: Auto generate data

petter — Sun, 11 Oct 2015 06:42:23 GMT

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

Re: Auto generate data

omid5ive — Sun, 11 Oct 2015 06:53:24 GMT

Thank you Petter