This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to calculate the number of days how long the current inventory lasts if nothing comes in.
My fact table is the following:
It should take the lastest value from Inventory Balance ( =700) and calculate how many days the Balance lasts with the forecasted demand.
The correct answer with the data above should be 3 (700-200-100-80)
I'd like to do this in the visualization side, not in scripting. The reason is that I might have a product dimension and to be able to see the value with a selection of products.
How to do this? The result should be displayed in a text box.
Thanks in advance,
Sane way? Probably not...
View solution in original post
I don't know of any sane way to do this without changing the load script. Perhaps Stefan knows a way.
Damn it!!, I was so close, but had to jump on a call. I am glad I was moving in the right direction
glad that it works for your. I guess there are better way to solve your request, maybe with some small changes to the data model.
I guess the last inventory balance and the demand forecast is not changing with user selections per specific product?
So maybe it's possible to calculate your requested outcome already in the script, or at least part of the information used in my expression.