Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Sunny,
Yes It is different Value,end user will enter this value for forecasting analysis.
Please find the attached for more clarifications
Thiru
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?
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
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