topic Re: Autogenerate in QlikView

Autogenerate

gayathridevi24 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please Explain Autogenerate With Example.

Thanks in Advance.

Thanks and Regards,

Gayathri Devi

MindaugasBacius — Mon, 29 Oct 2018 06:36:51 GMT

Few examples:

bommidoddi — Mon, 29 Oct 2018 06:51:10 GMT

Hi Gayathri,

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

Regards,

Seenu

gayathridevi24 — Mon, 29 Oct 2018 06:54:12 GMT

Thank you so much.

gayathridevi24 — Mon, 29 Oct 2018 06:54:30 GMT

Thank you so much