Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

autogenerate error

Hello,

Can you tell me, please, what am I doing wrong:

load

...

   recno() as numstring

resident Result;

let varRowCount=2*max(numstring);

temp:

load recno() as  row_counter

AutoGenerate(varRowCount);

Regards,

Alexa

1 Solution

Accepted Solutions
Employee
Employee

Re: autogenerate error

You need to use the peek function in order to store the numstring into the varRowCount variable.

I am sending you your example slightly modified

TEST:

load

...

   recno() as numstring

resident Result;

maxnumstring_table:

LOAD

  max(numstring) AS maxnumstring

Resident TEST;

let varRowCount= 2 * peek('maxnumstring', 0, 'maxnumstring_table' );

temp:

load recno() as  row_counter

AutoGenerate(varRowCount);

I hope this helps

Regards

Agis

2 Replies
Employee
Employee

Re: autogenerate error

You need to use the peek function in order to store the numstring into the varRowCount variable.

I am sending you your example slightly modified

TEST:

load

...

   recno() as numstring

resident Result;

maxnumstring_table:

LOAD

  max(numstring) AS maxnumstring

Resident TEST;

let varRowCount= 2 * peek('maxnumstring', 0, 'maxnumstring_table' );

temp:

load recno() as  row_counter

AutoGenerate(varRowCount);

I hope this helps

Regards

Agis

Not applicable

Re: autogenerate error

Agis Kalogiannis, thanks a lot!

Community Browser