Autogenerate() Rows from Field Values vs. Variable/Function Values

[Miles_Dyson]

Hello Qlik World. I am having a hard time understanding one aspect of the Autogenerate function. I have created 3 scenarios to demonstrate the question.

Scenario 1: Autogenerate works

Scenario 2: Autogenerate works

Scenario 3: Autogenerate returns an error

Here is the error message

So my question is why does Autogenerate return an error code in the 3rd example stating field not found when the field is specified in the preceding INLINE table?

Lastly, I also would like to learn why all these scenarios run properly when the Autogenerate fx line is commented out (even the 3rd scenario). Does this mean that the Autogenerate fx is optional when we only want to generate 1 record for each iteration?

Thank you folks.

[MeehyeOh · Accepted solution]

Hi, @Miles_Dyson 

As I know,

1. Autogenerate is used if data should be automatically generated by Qlik Sense.
There are the following points to note.
"The field list must not contain expressions which require data from an external data source or a previously loaded table, unless you refer to a single field value in a previously loaded table with the Peek function."

Therefore, Autogenerate cannot be used with 'Resident', 'From', or 'precording load'.

The third scenario you posted failed because you used "Autogenerate" with the preceded load data field.

2. "Autogenerate" is not optional when generate 1 record for each iteration.
It's only necessary when generate new data in "Qlik Sense".

[Miles_Dyson]

Thank you MeehyeOh,

Your explanation makes everything clear.