AutoGenerate & Iterno()

[qlikview979]

Hi Experts,

What is the main Difference between "AutoGenerate & Iterno()"  ?

Regards,

Mahesh

[MK_QSL · Accepted solution]

Autogenerate is used for automatically generating data in qv.

IterNo( ) returns an integer indicating for which time one single record is evaluated in a load statement with a while clause. The first iteration has number 1.

[qlikview979]

Hi  Bro,

Thanks for your support

Regards,

Mahesh

[MK_QSL]

Use below script in your qvw.

Let vMinDate = Num(Date(YearStart(Today())));

Let vMaxDate = Num(Date(Today()));

Calendar:

Load

  RowNo() as RowNumber,

  IterNo() as IterNumber,

  Date($(vMinDate) + IterNo() - 1) as Date

AutoGenerate 1

While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

Now use the same and change AutoGenerate 2

Try to analyze difference between output of those two.

[marcus_sommer]

Autogenerate will repeat a load-statement x-times (defined manually or per expression) and each time in the same way - you could only functions like recno/rowno to adjust anything.

By using from iterno() in combination with a while-statement you could repeat the load from the various records x-times depending on your conditions.

- Marcus

[qlikview979]

Hi Bro's

Thanks.