Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner - Creator II
Partner - Creator II

Take average off previous months in PL

Dear all,

I have created a profit and loss statement with an interval match.

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&L but still take an average per account in the P&L

Regards, Paul

0 Replies