Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Partner

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

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.

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)
kaveri_bhar123
Contributor II
Contributor II

Hi Thiru,

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

sum(sales)*(1+ vGrowthrate)

Best regards,

Kaveri