Here is a problem I couldn't solve so far, (although I think it is a quite common one) :
* in my data I have ItemsProduced datalines, with a ProductionDate
* I also have ItemsSold datalines, also with SalesDate.
At any time the Stock = ItemsProduced - ItemsSold.
I can get this easily in a straight table, with (eg) month as a dimension.
This shows for each month the Production, Sales, as well as the movement of the Stock, ie. growing or shrinking.
I can even accumulate that, so it shows the total Stock, not just the movement for that month.
The problem however is, that when you select a time window (a year, month, ..) the accumulation always starts from 0
In fact it should start from the value it had by accumulating everything before the selection window.
I can calculate the value (eg in a text box) of Stock before the selection window :
= Sum ({$<year=, month=, datumNum={"< $(vStart)"} >} ItemsProduced)
- Sum ({$<year=, month=, datumNum={"< $(vStart)"} >} ItemsSold)
This tells qlikview to ignore the selection in year and month, and rather calculate over everything before 'vStart'. vStart is a variable defined as
=min(datumNum)
a similar trick is done with vEnd...
Problem is : I can't get this work inside the straight table... I'd like to show the actual stock in a selected time window, so adding the stock that was built up before the selected time window to the additional stock movement in the months of the selection time window..
Your help is appreciated!
