Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Forcasting in Qlikview

Hello Experts,

        Can anyone tell me about forcasting in Qlikview.

        Is it possible..? If yes then how to implement it and also provide me documents for the same.

Regards & Thanks,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
13 Replies
Not applicable

Forecasting can be so many things depending on industry and terminology. Can you descibe what you mean and what you want to do or what your expected result whould be?

Are you aiming to create a forecast from Qlikview based on previous transactions, or are you loading a forecast and what to visualize this against actual transactions?

Regards
Robert

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Hi,

    Yes I am aiming to create a forecast based on the previous transactions. But I am unaware of the forecasting algorithms and I want to know is there any functionality in Qlikview which i am unaware of which can help me to obtain the forecasting.

    Any information on these will be a grateful help.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

We do a lot of forecasting at the company where I work and I have yet to see a built in QV function that would calculate forecasting.  We just have the forecast elements created on a separate table on the database and link by a common key and bring that into QV.

Not applicable

Besides normal math functions, there's a whole bunch of statistical aggregation functions in Qlikview. Look at page 374 to 380 in the Reference Manual. (in the script expression section)


The reference manual is stored in your Qlikview installation folder, like "C:\Program Files\QlikView\Documentation"


If you want to generate a forecast, it is in my experience best to do this in the load script.

This is how I've done it previously.

1. Load the source data into a transaction table.
2. Resident this loaded data with the appropriate expressions into a new forecast table.
3. Save the forecast table into a new QVD.

Regards
Robert

Not applicable

Robert

Do you have an example of the script used to create the forecast table that you can share?

raghavsurya
Partner - Specialist
Partner - Specialist

Hi Kaushik,   I have created a forecasted Profit and Loss Account and Balance sheet as well using past year's data and Input fields/Input boxes to predict current year's forecasts.  Do let me know if you are looking at any specific model on forecasting.  Regards, Raghav

RSvebeck
Specialist
Specialist

Hi. Here is a extremely simple example.

Best Regards
Robert Svebeck
(I was was forced to create a new acount because it was not possible to change mail for some reason...)

Svebeck Consulting AB
Not applicable

Thank you robert. This is helpful but what I am trying to do is to calculate a forecast for the future months based on the prior month value

If Sept we sold 2000 units and the user input 10% Month over Month Growth then October would generate 2200 as forecast.

The user would need have the option of inputting a Month over Month % growth

I tried using the rangesum(above(sum())) function in my pivot object but the rowno() is set to 1 for all columns so the rangesum(above()) is not working

I also tried using set analysis to sum for the prior month IF the sum of sales for that month is 0 and that did not work either. i.e. =sum({<MonthsFromCurrentMonth={'-1'},[Organizational Roll-up]={'Premier'}>}[Activity Count]) but this results in the current month for each column only. Keep in mind my pivot is reversed. The expressions are the rows and the dimensions are the columns. This, I am assuming, is the reason that the rowno() is set to 1 for each month column.

Not applicable

I tried using the columnno() and the below but same issue, I get 0 for all months

=rangesum(before(sum(),1))