topic Re: STOCKS by Date in QlikView

STOCKS by Date

ecolomer — Sun, 05 Mar 2017 12:49:38 GMT

I have a table with the following data:

Product, Date, Stock

aaaa, 30/01/2017, 100

bbbb, 25/01/2017, 150

cccc, 30/01/2017, 120

...

And we also have for each date, the movements (inputs and outputs) produced in another table:

Product, Date, Input, Output

aaaa, 25/01/2017, 40,0

aaaa, 15/01/2017, 0, 30

aaaa, 10/01/2017, 50,0

bbbb, 20/01/2017, 0, 35

bbbb, 16/01/2017, 22, 0

bbbb, 14/01/2017, 14,0

bbbb, 12/01/2017, 0, 35

cccc, 28/01/2017, 16,0

cccc, 26/01/2017, 0,18

cccc, 24/01/2017, 0, 10

....

We have to get a table with a record for each product and date (from min Date to Max Date) indicating the stock at that date.

Product, Date, Stock

Thank's in advance

Anil_Babu_Samineni — Sun, 05 Mar 2017 13:14:17 GMT

May be you have some idea to see the UI. Can you let us know your expected Table to see

ecolomer — Sun, 05 Mar 2017 14:00:33 GMT

Hi,

Here you have an excel with data and result expected

Thank's in advance

Saludos,

Enrique Colomer

Anonymous — Sun, 05 Mar 2017 18:45:54 GMT

this is just a demo, for printing every product on a separate sheet, you'll need NPrinting, macros or a patient assistent