Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarjuna005
Contributor III
Contributor III

Pass variable from user to script ?

My requirement is user wants to enter the  StartDate and EndDate in production server. 
 

 

I have a script that has two variables, StartDate and EndDate.

right now its working in my local desktop but i want to do the same in QMC server.

below is the solution working for me in local desktop     

Let vDate = Input('Enter Start Date (MM/DD/YYYY)' , 'Input required');

but i want this solution to work in QMC as well please let me know how to do it in QMC.

Thanks for your help!!

 

Labels (1)
  • QMC

4 Replies
chrismarlow
Specialist II
Specialist II

Hi,

When you put this on the server I would assume that the reload is controlled by the server scheduling, rather than user triggered when they open the document.

Where I worked previously all of these date settings ended up wither being calculated in script (so last month end, last quarter etc.) or set in a database that users had a simple UI to manage values through that the QlikView app could call from (Excel was forbidden), but where then the same for all users.

Depending on what your script does could you not run for all dates & then have the app react to user inputs in each session of use? I think that would be a more normal operating model, but happy to be corrected.

Cheers,

Chris.

MayilVahanan

Hi @nagarjuna005 

If the user want to see only certain dates based on user input. 

In that case, you can create calendar object for start and end date, and can filter the dates based on the user requirement.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
nagarjuna005
Contributor III
Contributor III
Author

Hi Mayil,

thanks for your response.

user wants to enter start date and end date based on their need from server so that not changing the dates manually from outside of qlikview. so is there way to do it in QMC plz let me know

nagarjuna005
Contributor III
Contributor III
Author

Hi Chris,

thanks for your response.

user wants to enter start date and end date based on their need from server so that not changing the dates manually from outside of qlikview. so is there way to do it in QMC plz let me know