Autogenerate

[gayathridevi24]

Hi All,

Please Explain Autogenerate With Example.

Thanks in Advance.

Thanks and Regards,

Gayathri Devi

[MindaugasBacius · Accepted solution]

Few examples:

Autogenerate Your Data

https://data-flair.training/blogs/qlikview-autogenerate/

[bommidoddi]

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]

Thank you so much.

[gayathridevi24]

Thank you so much