Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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?