Discussion Board for collaboration on QlikView Scripting.
table1 - "Inventory cost":
fields - Item, DateCome, QuantityCame, CostCame, Spending1, Spending2
table 2 - "Items movement":
fields - Item, DateMovement, InOrOut, QuantityMoved, Stock
Final table (what I want to see):
Stock, Item, AvgCost, QuantityForTheBeginning, QuantityIn, QuantityOut, QuantityInTheEnd.
Also, where the problem can sit in my opinion, the script
Left Join (CalendarInventoryCameTemp)
Date as DateCome
DROP Table CalendarInventoryCameTemp;
The same script for DateMovement.
I tried to do as you said, Jonathan, thank you.
But the result is the same. Some items is shown, and some is not. And I don't see the logic there. Because they all have the data in fields.
My intuition tells me Date making some problems there.
Please, any suggestions. 2nd day of a headache(