topic Re: Build batch link in QlikView

Build batch link

Mon, 02 Feb 2015 20:21:26 GMT

Hi, I trying to link different product code in process you can see that I end up with batch and work order, you can see that I usied batch to specific work order then in second row batch number equal work order form previous stage.

I looking to link all 8 rows so when I search 64500 batch I can see all below rows linked to original batch.

Could you help ?

Thanks

Re: Build batch link

robert_mika — Mon, 02 Feb 2015 20:38:35 GMT

Could you give some more details?

Attached your data or working file?

Re: Build batch link

Mon, 02 Feb 2015 20:50:25 GMT

Please see attachment.

Thanks

Re: Build batch link

robert_mika — Mon, 02 Feb 2015 21:02:51 GMT

Wygldalo mi to na zrzut z Excela dlatego poprosilem o ten plik(tez).

W domu uzywam tylko Personal Edition wiec spojrze na to jutro w pracy, chyba ze ktos bedzie szybszy albo dolaczysz plik z Excel.

Re: Build batch link

Mon, 02 Feb 2015 21:28:30 GMT

Plik exela. Dzieki

Re: Build batch link

robert_mika — Mon, 02 Feb 2015 21:33:45 GMT

Ok this is your outcome.

What about the data set?

Re: Build batch link

Mon, 02 Feb 2015 21:52:08 GMT

This what I can get in sql table.

Re: Build batch link

Tue, 03 Feb 2015 19:27:11 GMT

Can anyone help me ?

Re: Build batch link

robert_mika — Tue, 03 Feb 2015 20:55:14 GMT

Could post more data or ad another example?

I can not follow your logic.

Re: Build batch link

sujeetsingh — Tue, 03 Feb 2015 21:00:40 GMT

Just what you need to do is to create a table structure with the same representation in your Data Model.

Load your entry from the table using resident load.

Use order by Productcode and use previous function as Previous 1 then 2 then 3 what you need.

Re: Build batch link

Tue, 03 Feb 2015 22:06:26 GMT

Please see below data.

Thanks