topic Re: autogenerate error in Qlik Learning Discussions

autogenerate error

Fri, 24 Oct 2014 13:45:04 GMT

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

Re: autogenerate error

Agis-Kalogiannis — Fri, 24 Oct 2014 14:27:50 GMT

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

Re: autogenerate error

Mon, 27 Oct 2014 08:47:03 GMT

Agis Kalogiannis, thanks a lot!