Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to transform a table?

Hi!

I have stock table with receives and delivery from warehouse.

I would want to transform this table into new table where I could get info about value of delivery goods.

So basically FIFO what first goes int o stock had to also leave first form warehouse.

So from table:

Datequantitystockordervalue
2201201415159020111,3
23012014-21380450
23012014-31080451
24012014-5580452
2501201410159020212,5
26012014-11480453
27012014-31180454
28012014-51080455
29012014-1980456
30012014-1880457
100220145139020313,7
30022014-94

80458

I would like to get this table:

Dateorderreceivequantityvalue
230120148045090201211,3
230120148045190201311,3
240120148045290201511,3
260120148045390201111,3
270120148045490201311,3
280120148045590201111,3
280120148045590202412,5
290120148045690202112,5
300120148045790202112,5
300220148045890202813,7
300220148045890203813,7
300220148045890203813,7
1 Reply
Not applicable
Author

Well I found out as I made few mistakes in both tebles.. this are new better tables..

Datequantitystockordervalue
2201201415159020111,3
23012014-21380450
23012014-31080451
24012014-5580452
2501201410159020212,5
26012014-11480453
27012014-31180454
28012014-5680455
29012014-1580456
30012014-1480457
10022014599020313,7
30022014-9080458

And second table::

Dateorderreceivequantityvalue
230120148045090201211,3
230120148045190201311,3
240120148045290201511,3
260120148045390201111,3
270120148045490201311,3
280120148045590201111,3
280120148045590202412,5
290120148045690202112,5
300120148045790202112,5
300220148045890203413,7
300220148045890203513,7