topic Re: Forecasting data with input values in QlikView

Forecasting data with input values

Wed, 25 Nov 2020 16:16:04 GMT

Please find the atathced

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: Forecasting data with input values

susovan — Wed, 15 Jun 2016 11:43:54 GMT

Hi Thiru,

Can you share "sampledata.xlsx"?

Re: Forecasting data with input values

Wed, 15 Jun 2016 12:44:45 GMT

Please find the attached QVW file here

Forecasting data with input values

Thiru

Re: Forecasting data with input values

Thu, 16 Jun 2016 11:25:38 GMT

Have u got my Qvw?

Re: Forecasting data with input values

Anil_Babu_Samineni — Thu, 16 Jun 2016 18:17:48 GMT

Thiru,

Check your Mail

Re: Forecasting data with input values

Fri, 17 Jun 2016 05:45:59 GMT

Hi Anil,

I didn't get anything in my mail,can you please forward it agian

Thanks

Thiru

Re: Forecasting data with input values

sujeetsingh — Fri, 17 Jun 2016 05:56:49 GMT

I can not get you what you need in forecasting?

Re: Forecasting data with input values

Fri, 17 Jun 2016 06:33:27 GMT

Hi Sujeet,

We can get the forecasting analysis using Lineast_M functions,but

my requirement is

1. end user want to give the growth rate(as a drop down using variable),using end user value the forecasting need to reflect.

2.Sales value also he want to add in some month/year based on that again forecasting need to reflect.

Thanks

Thiru

Re: Forecasting data with input values

Anil_Babu_Samineni — Fri, 17 Jun 2016 06:35:07 GMT

Thiru,

Check the Attachment.

Re: Forecasting data with input values

Anonymous — Fri, 17 Jun 2016 07:33:36 GMT

Hi Thiru,

You need to include this variable for growth rate in your expression. For eg:

sum(sales)*(1+ vGrowthrate)

Best regards,

Kaveri