autogenerate

[Anonymous]

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..

[Anil_Babu_Samineni]

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

[engishfaque]

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

[Anonymous]

thanks..

[its_anandrjs]

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

[Anonymous]

Hi ahamed...

now i got idea about autogenerate thanks..

[Anonymous]

thank u so much

[dineshm030]

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

Refer the attachment.

[#9]

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