Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use variable as input field for using as a column

Hi I have scenario

Want to create a variable,using this i want to create straight table like below

Year   SlaesGrowth(Variable)

2001     ---------------

2002     --------------

2003   --------------

2004      ----------------

If  end user enters a value,based on this want to calculate some of other expressions.

Please suggest how to achieve he above

Thiru

5 Replies
sunny_talwar

Would it be the same value for each year? or do you want to be able to add different value for growth for each year? If you need to be able to enter different values, you might need a InputField here.

Read here for InputField:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/Input_Fields.htm

Inputfield example.qvw

Not applicable
Author

Hi Sunny,

Yes It is different Value,end user will enter this value for forecasting analysis.

Please find the attached for more clarifications

INPUTFILED

Thiru

sunny_talwar

Are you using a single growth rate in the attached sample and you would want to see a new column where you would want to enter different growth rate numbers?

Not applicable
Author

only one column,in future years i mean after 2016 i need to enter the values for that i created salesgrowthrate1 as alias (since i am new to this tool).

what i want is i need a input column which enduser can enter the values in future  so that he will anaylse .

Thiru

Not applicable
Author

Hi Sunny,

My requirement is

1.forecasting analysis of sales growth rate(using linear functions i got that)

2.based on startdate and enddate the period of X-Axis need to be change(using input boxes i got that)

3.Based on sales growth rate (input box)  the future years need to reflect means sales growth rate if i add more n percentage how it will

$(Sales Growthrate) added in formula) Got it

3.Based on impact (i.e input field) end user want to add values in input field,so that again this values as to reflect in forecasting analysis(Doted lines in chart)

4.The crashed date(meanschart touching the 100% as target) will vary based on the above.

Thanks

Thiru