Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Please, help me solve such a task.
Have
ItemId BatchId Stock level AvgOutcome NumOfDays DayOutOfStock (today + num of days)
I1 1 100 25 4 23/04/2011
I1 2 150 25 6 need to 23/04/2011(previous value) +6 (current num of days) !
I use today() + NumOfDays formula.
Thanks in advance,
Cheers,
Michael
File in attachment[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0312.StockAnalysis.zip:550:0]
Hello Michael,
In both a straight or pivot table the following should work
=Above(Today() + NumOfDays) + DayOutOfStock
Hope that helps.
Hello Michael,
In both a straight or pivot table the following should work
=Above(Today() + NumOfDays) + DayOutOfStock
Hope that helps.
Hi Miguel,
Thanks for answer.
Could you also tell me what formula to use if I have only NumOfDays and need to calculateDayOutOfStock for each following row?
Like this
Item1 Batch1 Stocklevel = 100 Avgoutcome = 50 NumOfDays = 2 Today()+2 = Date1
Item1 Batch1 StockLevel = 50 Avgoutcome = 50 NumOfDays = 1 - Either Today()+NumOfDays(prev) + NumOfDays(curr), or Date1 + NumOfdays(curr)
?
Maybe Above(today()+NumOfDays)+NumOfDays?
Hello,
I'm getting a bit lost because I don't know where do you have that "Date1" field. But according to your expressions above
Today() + Above(NumOfDays) + NumOfDays
should work.
Hope that helps.