Discussion Board for collaboration on QlikView Scripting.
I am trying to change my table , which is having a quatity of 1 to 5 into a tabel with single rows for each Quantity
If have the below script working but it is also doing the load for number 3 and 4, I don't want to script running for values which don't exist
any idea, this is just a small example in realtime i have High Qty exceptions ?
For i = num(1,00) to num($(vMax)) for j= 1 to $(i)
resident x where QTY=$(i);
X: LOAD ID, 1 as QTY
While IterNo()<= QTY;
LOAD * INLINE [
ID, QTY A, 1 B, 2 C, 5