topic Re: how to create auto generate?? in QlikView

how to create auto generate??

Fri, 20 Nov 2020 18:02:30 GMT

how to create auto generate??

Re: how to create auto generate??

Sat, 08 Nov 2014 06:56:46 GMT

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

Re: how to create auto generate??

arulsettu — Sat, 08 Nov 2014 07:13:13 GMT

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.

Re: how to create auto generate??

maxgro — Sat, 08 Nov 2014 08:17:30 GMT

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

Re: how to create auto generate??

Anonymous — Wed, 28 Mar 2018 12:39:12 GMT

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

Re: how to create auto generate??

suren946 — Wed, 28 Mar 2018 12:45:39 GMT

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

While + IterNo() -1 <=?

Re: how to create auto generate??

Anonymous — Wed, 28 Mar 2018 13:08:35 GMT

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