How to get the forecasting data?

[#1]

Hi

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

[#2]

Hi

Please find the below for formula which i am using

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

Thanks

Thiru

[#3]

[Anil_Babu_Samineni]

Thiru,

Something like this...

[avinashelite]

check this threads , you get an idea

How to do Forecasting In Qlikview( with Example)

Forecasting in Qlikview

[#6]

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

[#7]

Yes Exactly

[#8]

Hi

Anil

INPUTFILED

Please find the attached

Thiru

[Anil_Babu_Samineni]

Thiru,

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

[#10]

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