topic Re: How to get the forecasting data? in QlikView

How to get the forecasting data?

Wed, 25 Nov 2020 16:16:04 GMT

I have a scenario,

want to show forecasting data in the chart for 10 years based on existing can you please let me know if any body has donr the same

Thanks in advance

Thiru

Re: How to get the forecasting data?

Wed, 08 Jun 2016 07:04:12 GMT

Please find the below for formula which i am using

=AVG({$<[Fiscal Year] ={">=$(StartDate) <=$(EndDate)"}>} [Sales (%)])

Thanks

Thiru

Re: How to get the forecasting data?

Wed, 08 Jun 2016 07:07:52 GMT

Re: How to get the forecasting data?

Anil_Babu_Samineni — Wed, 08 Jun 2016 07:11:52 GMT

Thiru,

Something like this...

Re: How to get the forecasting data?

avinashelite — Wed, 08 Jun 2016 07:18:44 GMT

check this threads , you get an idea

How to do Forecasting In Qlikview( with Example)

Forecasting in Qlikview

Re: How to get the forecasting data?

Wed, 08 Jun 2016 07:27:32 GMT

As shown in the above i have three filters one startdate and second one enddate and third one growth rate

If i give 2005 to 2025 and growth rate is 5%

then upto today data will come from database from today this will add 5% per year and need to show foercasting data upto end date in doted lines

Please do the needful

Thiru

Re: How to get the forecasting data?

Wed, 08 Jun 2016 07:28:13 GMT

Yes Exactly

Re: How to get the forecasting data?

Wed, 15 Jun 2016 06:47:37 GMT

Anil

INPUTFILED

Please find the attached

Thiru

Re: How to get the forecasting data?

Anil_Babu_Samineni — Wed, 15 Jun 2016 07:36:02 GMT

Thiru,

Can i know what are issues you facing one this Object...

Re: How to get the forecasting data?

Wed, 15 Jun 2016 07:56:21 GMT

Hi Anil,

1.want to show the input value Sales growthrate1 in forecasting data means if end user enters a value in particuler year so that it will change according to that.

2.the forecasting line meets the target in some year,want to know that year

means based on Sales Growth rate (input box) variable this will vary.

So want to know how to get that crashdate?

Thanks

Anil

Re: How to get the forecasting data?

Anil_Babu_Samineni — Wed, 15 Jun 2016 10:15:47 GMT

Thiru,

I thought what are expecting like If we have 3 Variables, in that Start_Year, End_Year & Sales Annual Growth

If i choose from first two variable like 2010, 2016 You want show only 2010-2016 Data from Whatever graph and meantime you want to show Selected data to Sales Annual Growth.

Is that you are referring...!

Re: How to get the forecasting data?

Wed, 15 Jun 2016 10:21:46 GMT

Hi Anil

1.date range is always from satrtdate and enddate(from variables)

2.Sales Annual Growth Rate is a variable where it will add another growth percentage for meeting the 100% of their sales in future

(For example if they selected 3.5 from Sales Annual Growth Rate it will add 3.5 extra sles growth in their future years)

3.Finally input column here also they want to give their sales growth in the future years how it will reflect in future (doted lines)

Thank

Thiru

Re: How to get the forecasting data?

Wed, 15 Jun 2016 10:43:39 GMT

Forecasting data with input values