topic Re: Calculating values for certain months in QlikView https://community.qlik.com/t5/QlikView/Calculating-values-for-certain-months/m-p/966626#M956525 <HTML><HEAD></HEAD><BODY><P>That should be possible. Perhaps sum({&lt;Month={"&lt;10"}&gt;}Actual). I don't know if you have month numbers available. You could also try sum({&lt;Month-={'October 2015','November 2015','December 2015'}&gt;}Actual) if your month field contains that kind of values.</P></BODY></HTML> Wed, 11 Nov 2015 14:16:15 GMT Gysbert_Wassenaar 2015-11-11T14:16:15Z Calculating values for certain months https://community.qlik.com/t5/QlikView/Calculating-values-for-certain-months/m-p/966625#M956524 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I have the following issue:</P><P></P><P>Actual sales-figures come in by month (January - November 2015).</P><P>Forecast-figures are from October - December 2015.</P><P></P><P>If I now want to show ACTUAL / FORECAST, I must not consider November for actual values, because this is already included in FORECAST.</P><P>Could this be done within a sum-formula ?</P><P></P><P>Regards,</P><P>Reinhold</P></BODY></HTML> Tue, 10 Nov 2015 07:48:04 GMT https://community.qlik.com/t5/QlikView/Calculating-values-for-certain-months/m-p/966625#M956524 reinholdgraf 2015-11-10T07:48:04Z Re: Calculating values for certain months https://community.qlik.com/t5/QlikView/Calculating-values-for-certain-months/m-p/966626#M956525 <HTML><HEAD></HEAD><BODY><P>That should be possible. Perhaps sum({&lt;Month={"&lt;10"}&gt;}Actual). I don't know if you have month numbers available. You could also try sum({&lt;Month-={'October 2015','November 2015','December 2015'}&gt;}Actual) if your month field contains that kind of values.</P></BODY></HTML> Wed, 11 Nov 2015 14:16:15 GMT https://community.qlik.com/t5/QlikView/Calculating-values-for-certain-months/m-p/966626#M956525 Gysbert_Wassenaar 2015-11-11T14:16:15Z