Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Afternoon.
I would like to enable a User to specify the number of Month's data to load. I have a variable in the script "SET v_Reload_Months = '24';" that gets used in the LOAD script,
LOAD * FROM [TRANSACTIONS_ALL.qvd](qvd)
WHERE (Monthstart(Date) <= monthstart(today()) and Monthstart(Date) >= monthstart(today(),-'$(v_Reload_Months)'));
This works fine at reload time. I am looking for a way to let the user change the variable in the app and then reload the app for the new number of months. The variable is visible in the app but I don't know how to get the value back to the script!
Any ideas? Thank you.
Hi,
Are you looking for something like this?
https://community.qlik.com/t5/QlikView-App-Development/Parameters-in-script-prompt/td-p/441106
Hi.
Thanks for the reply. If I understand you correctly, the user needs to update the spreadsheet every time they want to change the variable value? This is in a Forecasting environment and they may want to run up to 20 simulations in a day. May be a bit cumbersome. I will give it a try.
Hi,
Are you looking for something like this?
https://community.qlik.com/t5/QlikView-App-Development/Parameters-in-script-prompt/td-p/441106