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: 
Not applicable

Forecasting data with input values

Hi

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

9 Replies
susovan
Partner - Specialist
Partner - Specialist

Hi Thiru,

Can you share "sampledata.xlsx"?

Warm Regards,
Susovan
Not applicable
Author

Hi

Please find the attached QVW file here

Forecasting data with input values

Thiru

Not applicable
Author

Have u got my Qvw?

Anil_Babu_Samineni

Thiru,

Check your Mail

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Hi Anil,

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

Thanks

Thiru

sujeetsingh
Master III
Master III

I can not get you what you need in forecasting?

Not applicable
Author

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

Anil_Babu_Samineni

Thiru,

Check the Attachment.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Hi Thiru,

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

sum(sales)*(1+ vGrowthrate)

Best regards,

Kaveri