I would like to use Qlikview to predict future fail rates. I am struggling with the approach.
The best way to explain it is to show an excel chart. I am trying to predict the pink and white cells. The challenge is every predicted cell has it's own unique formula. (I included the formulas in excel)
I have reviewed Set Analysis. The only way to do this is through a massive if statement. I have also reviewed the after, before, etc commands. I just can't see the end state and determine the best solution. Ideas?
There are a few more caveats (dynamic, short/long sales time frames, etc), but I think I can figure those out if I can get a working model.