topic Re: Linking two tables, first in first out in QlikView

Linking two tables, first in first out

Wed, 06 Jan 2016 15:12:42 GMT

Hello,

I want to link 2 tables and show the result in a chart, fifo wise:

Is there a way I could manage this?

Thanks in advance!!

Gysbert_Wassenaar — Wed, 06 Jan 2016 17:24:38 GMT

This assumes your tables are already in the order you want:

Result:

LOAD

Article,

qty,

autonumber(RecNo(),Article&1) as Row

FROM Table1;

JOIN (Result)

LOAD

Article,

Salesprice,

autonumber(RecNo(),Article&2) as Row

FROM Table2;

Wed, 13 Jan 2016 13:06:13 GMT

Hello,

Thanks for this idea, but unfortunatly the tables in the right order.

My result for this example is now:

Gysbert_Wassenaar — Wed, 13 Jan 2016 17:58:21 GMT

Apparently the counters to the autonumber function need to be more different. I've edited the solution above to reflect this.

Thu, 14 Jan 2016 16:19:24 GMT

Hi Gysbert,

Everything worked out fine! Thank you