Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Predictive Pivot Table

Hello all!

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.

I'm open to suggestions.