Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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