Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ecolomer
Master II
Master II

STOCKS by Date

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

1 Solution

Accepted Solutions
ecolomer
Master II
Master II
Author

Hi,

Here you have an excel with data and result expected



Thank's in advance

Saludos,

Enrique Colomer

View solution in original post

3 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ecolomer
Master II
Master II
Author

Hi,

Here you have an excel with data and result expected



Thank's in advance

Saludos,

Enrique Colomer

Anonymous
Not applicable

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