topic Take average off previous months in PL in QlikView https://community.qlik.com/t5/QlikView/Take-average-off-previous-months-in-PL/m-p/1325424#M410139 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have created a profit and loss statement with an interval match.</P><P></P><P>I also want to include a rest of the year forecast. So what I want is to fill in the data for upcoming months with an average of the last months. But I can't get it to work. How can I make a set analysis where I don't look at the MonthYear in my P&amp;L but still take an average per account in the P&amp;L</P><P></P><P>Regards, Paul</P></BODY></HTML> Tue, 20 Jun 2017 14:27:43 GMT pauldamen 2017-06-20T14:27:43Z Take average off previous months in PL https://community.qlik.com/t5/QlikView/Take-average-off-previous-months-in-PL/m-p/1325424#M410139 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have created a profit and loss statement with an interval match.</P><P></P><P>I also want to include a rest of the year forecast. So what I want is to fill in the data for upcoming months with an average of the last months. But I can't get it to work. How can I make a set analysis where I don't look at the MonthYear in my P&amp;L but still take an average per account in the P&amp;L</P><P></P><P>Regards, Paul</P></BODY></HTML> Tue, 20 Jun 2017 14:27:43 GMT https://community.qlik.com/t5/QlikView/Take-average-off-previous-months-in-PL/m-p/1325424#M410139 pauldamen 2017-06-20T14:27:43Z