topic Re: Using variables to forecast? in QlikView https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685947#M1076084 <HTML><HEAD></HEAD><BODY><P>oh nevermind.. it's the sum... Silly me, thanks!</P></BODY></HTML> Wed, 30 Jul 2014 20:41:09 GMT Anonymous 2014-07-30T20:41:09Z Using variables to forecast? https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685944#M1076081 <HTML><HEAD></HEAD><BODY><P>Hi, I am trying to calculate a quarterly forecast using current QTD runrates for 2 different dimensions (Business unit and segment). I was able to calculate the runrates for both but when I applied the runrates * the total EST using the following formula, it gave me wrong answers. Can someone help please? TIA!</P><P></P><P>sum(if(Segment = 'A', 200000, if(Segment = 'B', 300000, if(Segment = 'C', 400000, if(Business Unit = 'AA', 200000, if(Business Unit ='BB', ...)))))) * (Runrate/100)</P><P></P><P>Please see screenshot below.</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/63415_pastedImage_0.png" style="width: 620px; height: 194px;" /></P></BODY></HTML> Wed, 30 Jul 2014 19:49:15 GMT https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685944#M1076081 Anonymous 2014-07-30T19:49:15Z Re: Using variables to forecast? https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685945#M1076082 <HTML><HEAD></HEAD><BODY><P>Maybe you could try it like this</P><P></P><P>sum(if(Segment = 'A' AND [Business Unit] = 'AA',&nbsp; 200000, if(Segment = 'B', 300000 AND [Business Unit] ='BB' , if(Segment = 'C', 400000 AND [Business Unit] ='CC')))) * (Runrate/100)</P></BODY></HTML> Wed, 30 Jul 2014 20:11:38 GMT https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685945#M1076082 rustyfishbones 2014-07-30T20:11:38Z Re: Using variables to forecast? https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685946#M1076083 <HTML><HEAD></HEAD><BODY><P>Thanks, sorry, doesn't work.... it gave me nulls instead...</P></BODY></HTML> Wed, 30 Jul 2014 20:31:34 GMT https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685946#M1076083 Anonymous 2014-07-30T20:31:34Z Re: Using variables to forecast? https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685947#M1076084 <HTML><HEAD></HEAD><BODY><P>oh nevermind.. it's the sum... Silly me, thanks!</P></BODY></HTML> Wed, 30 Jul 2014 20:41:09 GMT https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685947#M1076084 Anonymous 2014-07-30T20:41:09Z Re: Using variables to forecast? https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685948#M1076085 <HTML><HEAD></HEAD><BODY><P>So it's working now?</P></BODY></HTML> Wed, 30 Jul 2014 20:44:35 GMT https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685948#M1076085 rustyfishbones 2014-07-30T20:44:35Z Re: Using variables to forecast? https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685949#M1076086 <HTML><HEAD></HEAD><BODY><P>Yes! Thanks!</P></BODY></HTML> Wed, 30 Jul 2014 21:58:16 GMT https://community.qlik.com/t5/QlikView/Using-variables-to-forecast/m-p/685949#M1076086 Anonymous 2014-07-30T21:58:16Z