topic Re: Auto generate in Scripting in QlikView

Auto generate in Scripting

markgraham123 — Tue, 08 Sep 2015 17:20:11 GMT

Hi,

I'm working on a req. where i have

WHen i select Country A, i wanna display 1, 2, 3, 4, 5

So, here i wanna use a logic which helps to recognize number ranges between 1 and 5.

hic — Tue, 08 Sep 2015 18:13:26 GMT

LOAD Area,

From,

To,

From - 1 + IterNo() as Number

FROM Book2.xlsx (ooxml, embedded labels, table is Sheet1)

While IterNo() <= To - From + 1;

JonnyPoole — Tue, 08 Sep 2015 18:22:38 GMT

I used a loop to autogenerate all the values between from and to for each row of the data

The result is that you can see the full association of data in the UI:

Temp:

LOAD Area,

From,

FROM

(biff, embedded labels, table is Sheet1$);

let vNumRows=NoOfRows('Temp');

for i=0 to $(vNumRows)-1

let vStart=peek('From',$(i),'Temp');

let vEnd=peek('To',$(i),'Temp');

let vNumRowsToGenerate=$(vEnd)-$(vStart)+1;

load

Peek('Area',$(i),'Temp') as Area,

recno()-1+$(vStart) as Value

AutoGenerate $(vNumRowsToGenerate);

next i;

drop table Temp;

markgraham123 — Tue, 08 Sep 2015 22:10:56 GMT

Thanq Jonathan.

It worked

markgraham123 — Tue, 08 Sep 2015 22:11:14 GMT

Thanq Henric.

It worked