topic LOOP in SCRIPT in QlikView

LOOP in SCRIPT

Wed, 20 Jan 2010 17:30:46 GMT

Hi together,

I'll hope someone can help me.

I have to create Stock Transfer Orders. for example

2 items X and Y
3 companies A, B, C

company item onStock Sell_last_30days TRANSFER
A X 30 10 +20
B X 4 10 -6
C X 2 20 -18
A Y 4 20 -16
B Y 10 5 5
C Y 2 4 -2

I want to get a table like this:

comp item TransferOut TransferIN
A X 20 0
C X 0 18
B X 0 2 (because we have only 20 TransferOut)
B Y 5 0
A Y 0 5

Thanks for any help......

LOOP in SCRIPT

spsrk_84 — Thu, 21 Jan 2010 12:43:10 GMT

Hi,

Can u explain the base table structure i mean how the actual table looks like ,from which u want to create the table1 and table2..

if possible attach the data file .......

Cheers,

Ajay

LOOP in SCRIPT

Thu, 21 Jan 2010 17:33:10 GMT

Hi Ajay,

I've mad some XLS Files. I think i have the solution, but could you please check my
code. I think this must be done easier.

thanks

Wolfgang