topic Re: Autogenerate in QlikView

Autogenerate

Wed, 15 May 2013 15:05:39 GMT

Hi ,

I got a requirement in which i need to generate rows dynamically.

if v_temp=6

Code:

for j=1 to '$(v_temp)'

New_Month_Gen:

load

1 as temp

AutoGenerate '$(v_temp)'

;

Resul set should be :

temp

Please tell a solution.

Thanks,

Azim

Wed, 15 May 2013 15:19:47 GMT

This works:

SET

v_temp=6;

for j=1 to '$(v_temp)'

New_Month_Gen:

load

$(j) as temp

AutoGenerate (1);

next j

jagan — Wed, 15 May 2013 16:48:34 GMT

Hi,

Try like this

let v_temp = 6;

Temp:

load

RowNo() AS temp

AutoGenerate '$(v_temp)';

Hope this helps you.

Regards,

Jagan.