Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Sales vs Forecast from prior period

Hi,

I am trying to compare using a line chart by month year the sales versus  the forecast amount. However a forecast amount can change from one forecast cycle to another. Eg. We do a 24 month forecast for our  June 2020 sales in Jan, Feb etc.

I want to compare the amount that was sold against what was forecast for a month but being able to change the forecast cycle from  -1,-2,-3...-12  from that month year.

i want columns with the total qty by month year of forecast cycles from 1 to 12 months ago so that i can change in the chart the forecast cycle i want to compare against.

Yellow box here is a looking a forecast cycle 3 months previous of the month year.

2020-06-11 20_53_05-mape_logic (002).xlsx  -  Protected View - Excel.png

This will be used to calculate the MAPE so would like to do it in the load.

See sample chart below, explanation and data model

Thanks,

Laura

Labels (6)
0 Replies