Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
alwinsch
Contributor

Estimation - Prognose of future values

Hi all,

Can anybody help me or put me in the right direction.

I have attached a sample XLSX file with data.

i have calculated the profit for the last years/months

for the next months and also this month i want to make an estimation.

like this:

1. 10/2018 --> get profit from 10/2017

2. Multiply this by sum of profits from 09/2018-10/2017

3. Divide this by sum of profits from 09/2017-10/2016

for the next two months of this year 11 and 12/2018

i take the corresponding profit of 2017

but multiply and divide it with the same data as from 10/2018

or are there better solutions.

thanks.

kind regards,

Alwin