topic Re: autogenerate in QlikView

autogenerate

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

can anyone explain the autogenerate with good examples....i know meaning of this..but i need to know the output of this..how the output will come..

Re: autogenerate

Anil_Babu_Samineni — Thu, 24 Nov 2016 07:24:06 GMT

I assume this

Explanation foe below:

Rowno() Means will generate the values from 1 - ∞. So here, When ever you want to cut in between 1-∞ then you should use AutoGenerate function. From my below expression it generates 10 values from starting 1.

LOAD RowNo() as ID AutoGenerate 10;

I recommend you to create one qlikview work file(qvw) and then use this from script and select ID as field from UI then see how this works and try to change AutoGenerate value and see how this moving.

Hope helpful

Re: autogenerate

engishfaque — Thu, 24 Nov 2016 07:26:32 GMT

Hi Sindhu,

Autogenerate is used if data should be automatically generated by QlikView. (Please check QlikView Help)

For more,

Autogenerate Your Data

Kind regards,

Ishfaque Ahmed

Re: autogenerate

Anonymous — Thu, 24 Nov 2016 07:27:34 GMT

thanks..

Re: autogenerate

its_anandrjs — Thu, 24 Nov 2016 07:28:53 GMT

From Qlik Help

Load

RecNo( ) as A,

rand( ) as B

autogenerate(10000);

Note:- This load generate 10000 rows table with row fields this is based on the requirement.

Or you can search many post related to this on the community.

Regards

Anand

Re: autogenerate

Anonymous — Thu, 24 Nov 2016 07:31:20 GMT

Hi ahamed...

now i got idea about autogenerate thanks..

Re: autogenerate

Anonymous — Thu, 24 Nov 2016 07:32:18 GMT

thank u so much

Re: autogenerate

dineshm030 — Thu, 24 Nov 2016 08:27:54 GMT

Hi Sindhu,

We can do two types of AutoGenerate function.

Below is the content for your reference.

Header 1
AG: LOAD (RowNo() + 1) as Row_No AutoGenerate(25); AG1: LOAD (RowNo() + 1)-1 as Row_No1 AutoGenerate(25);

Header 1

AG:

LOAD (RowNo() + 1) as Row_No

AutoGenerate(25);

AG1:

LOAD (RowNo() + 1)-1 as Row_No1

AutoGenerate(25);

Refer the attachment.

Re: autogenerate

Thu, 24 Nov 2016 08:52:09 GMT

Hi Sindhu,

A most used example scenario of autogenerate :

Making dates :

vToday =Floor( Today());

vlast7thDay = $(vToday)-6;

LOAD $(vlast7thDay) + IterNo() -1 as Date

AutoGenerate 1 // this wil generate 1 row of Date Field each time the while loop repeats.

While $(vlast7thDay) + IterNo() -1 <= $(vToday);