topic Re: AutoGenerate & Iterno() in QlikView

AutoGenerate & Iterno()

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

Hi Experts,

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

Regards,

Mahesh

Re: AutoGenerate & Iterno()

MK_QSL — Tue, 21 Jun 2016 10:29:23 GMT

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.

Re: AutoGenerate & Iterno()

qlikview979 — Tue, 21 Jun 2016 10:32:36 GMT

Hi Bro,

Thanks for your support

Regards,

Mahesh

Re: AutoGenerate & Iterno()

MK_QSL — Tue, 21 Jun 2016 10:33:48 GMT

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.

Re: AutoGenerate & Iterno()

marcus_sommer — Tue, 21 Jun 2016 10:33:49 GMT

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

Re: AutoGenerate & Iterno()

qlikview979 — Tue, 21 Jun 2016 10:47:45 GMT

Hi Bro's

Thanks.