topic Predictive Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Predictive-Pivot-Table/m-p/161870#M35600 <HTML><HEAD></HEAD><BODY><P>Hello all!</P><P>I would like to use Qlikview to predict future fail rates. I am struggling with the approach.</P><P>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)</P><P>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?</P><P>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.</P><P>I'm open to suggestions.</P><P>Thanks</P><P>Rick</P></BODY></HTML> Sat, 27 Feb 2010 22:04:01 GMT 2010-02-27T22:04:01Z Predictive Pivot Table https://community.qlik.com/t5/QlikView/Predictive-Pivot-Table/m-p/161870#M35600 <HTML><HEAD></HEAD><BODY><P>Hello all!</P><P>I would like to use Qlikview to predict future fail rates. I am struggling with the approach.</P><P>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)</P><P>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?</P><P>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.</P><P>I'm open to suggestions.</P><P>Thanks</P><P>Rick</P></BODY></HTML> Sat, 27 Feb 2010 22:04:01 GMT https://community.qlik.com/t5/QlikView/Predictive-Pivot-Table/m-p/161870#M35600 2010-02-27T22:04:01Z