topic Re: How to use variable as input field for using as a column in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Wed, 15 Jun 2016 09:26:16 GMT

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

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

Wed, 15 Jun 2016 09:37:17 GMT

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

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

sunny_talwar — Wed, 15 Jun 2016 09:39:56 GMT

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?

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

Wed, 15 Jun 2016 09:57:35 GMT

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

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

Wed, 15 Jun 2016 10:09:00 GMT

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