topic Pass variable from user to script ? in QlikView

Pass variable from user to script ?

nagarjuna005 — Fri, 15 Nov 2024 23:29:32 GMT

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!!

Re: Pass variable from user to script ?

chrismarlow — Tue, 08 Dec 2020 09:23:34 GMT

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.

Re: Pass variable from user to script ?

MayilVahanan — Tue, 08 Dec 2020 09:37:58 GMT

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.

Re: Pass variable from user to script ?

nagarjuna005 — Tue, 08 Dec 2020 09:47:48 GMT

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

Re: Pass variable from user to script ?

nagarjuna005 — Tue, 08 Dec 2020 09:49:35 GMT

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