This is what I want to do:
I want to show the total stock in the past months. The stock is calculated using the current stock level with transaction history.
Problem is, when a month has no transactions, the stock level is 0. When calculating the total stock in that month, the total will be inaccurate.
Can someone please look at my Qlikview file? I have been struggling with this for the past 2 days.
Thanks in advance.
Maybe working with Full Accumulation would help in this case? This way, when there's no transaction the value will stay the same.
You should probably do this in the script using the peek() function. See more on
I tried this numerous times.. the problem is, my calculations get all messed up and they dont work anymore. Besides, I have like 500 different types of articles, generating a timespan of 4 years for every date would take forever. Is this possible maybe once a month?
I have the following code:
Load Min(Date) as MinDate, Max(Date) as MaxDate resident TempTable_Rates;
Let vMinDate = Peek('MinDate',-1,'MinMaxDate') - 1;
Let vMaxDate = Peek('MaxDate',-1,'MinMaxDate') ;
Drop Table MinMaxDate;
Load Date(recno()+$(vMinDate)) as [Date] Autogenerate vMaxDate - vMinDate;
date([Date]) as [Date],
If( IsNull( [MutationValue] ), Peek( [MutationValue] ), [MutationValue] ) as [MutationValue],
ORDER BY [KeyPart], Date DESC;
Drop Table TempTable_Rates;
Drop Table [Stock];
But it does not join the tables. It just shows an empty list of dates before showing the actual values. What am i doing wrong?
Please look at the attached file
In the expressions tab I have used the following expression