how to create auto generate??

[#1]

how to create auto generate??

[#2]

1. TempCalendar: 
2. LOAD 
3.                $(varMinDate) + Iterno()-1 As Num, 
4.                Date($(varMinDate) + IterNo() - 1) as TempDate 
5.                AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate); 
6.  

[arulsettu]

HI

autogenerate is data will be generated automatically

we can use this in functions like to increase dates

Ex:

Ceil(Rand() * 100) as
Amount

AutoGenerate(100);

here the data will be generated 100 times.

[maxgro]

autogenerate is used in a LOAD statement if data should be automatically generated by QlikView

some of the most common use is

- calendar generation (manojqlik)

- test data generation with rand (arul settu)

- log/trace of the script (see above)

all together

Rand: load   rand()*100 as field1 autogenerate 10;

Log: load 'INFO' as Type, 'After rand' as Info, now() as Time autogenerate(1);

let varMinDate = floor(Today());

let varMaxDate = num(makedate(2014,12,31));

sleep(1000);

Cal:

load

  $(varMinDate) + Iterno()-1 As Num,

    Date($(varMinDate) + IterNo() - 1) as TempDate

    AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

load 'INFO' as Type, 'After calendar' as Info, now() as Time autogenerate(1); 

[Anonymous]

Hi

trying the script I have the following error:

Field not found - <<=>

TempCalendar:

LOAD

                + Iterno()-1 As Num,

               Date( + IterNo() - 1) as TempDate

               AutoGenerate 1 While  + IterNo() -1 <=

thanks for any assistance

[suren946]

Sorry, if am wrong here but i feel that you need to specify the condition after

While  + IterNo() -1 <=?

[Anonymous]

Hi,

Below is the explanation for Autogenerate.

The function autogenerate will be used in a LOAD statement of Qlikview script. If you want to generate data by automatically in QlikView, we will use the autogenerate function.

Many example are post in the above, those will helps, when to we use it.

Thanks,

Venkata Sreekanth