Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
From - 1 + IterNo() as Number
FROM Book2.xlsx (ooxml, embedded labels, table is Sheet1)
While IterNo() <= To - From + 1;
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:
(biff, embedded labels, table is Sheet1$);
for i=0 to $(vNumRows)-1
Peek('Area',$(i),'Temp') as Area,
recno()-1+$(vStart) as Value
drop table Temp;