Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm fairly new to Qlik and I've now been stuck on an issue for a bit more than a day, so figured I'd try my luck here.
Essentially I have a table 'Temp_values' which contains an item number, date and average stock on that date, which is grouped by item number and date. I then try to create a Calendar which holds all the dates in the range i've selected (I think it works as intended up to this point but not completely sure).
What I'm having issues with is that there are a lot of null values as far from every item has a transaction associated with it each day, and I want to replace every null value after the first transaction of each item with the previous known value so that it can be plotted nicely and I can take an average per time period that is accurate.
My code looks like this:
Everything appears to be working correctly.
Just exchange your long expression in the Values table with this:
Coalesce(StockLevel, Peek(StockLevel)) as StockLevel
And also drop all no longer needed tables at the end:
Drop Tables Temp_values, MinMaxDate, Calendar;
Everything appears to be working correctly.
Just exchange your long expression in the Values table with this:
Coalesce(StockLevel, Peek(StockLevel)) as StockLevel
And also drop all no longer needed tables at the end:
Drop Tables Temp_values, MinMaxDate, Calendar;