Discussion board where members can get started with Qlik Sense.
Is it possible to define a variable in the load script, then have it updated by user input in a sheet and then trigger a reload of that load script?
If not can you please weigh in. I haven't seen anything about this anywhere and just want to know if it is even possible.
Is that actually reloading the script or is it just changing a copy of a variable that was loaded into the sheet?
For instance, if I used your setup to pass two variables, in my case dates, to a stored procedure, would it actually reload the script and bring down the new data?
Yes, but you need to update the extension for two variables it's made for just 1 variable for now.
If you can do that it will be great/just tell me I'll add it for you.
Yes script is getting reloaded & as you can see I have passed thar variable ad parameter for auto increment
Will this work for you ?
I'll suggest you give it a spin first & test the reloaded data, if it meets your requirement then start the upgrade of extension/tell me I'll do it.
Thanks for all the feedback and the offer Ajay. I will test this more and let you know. I really appreciate the help.
My other concern is security. Users will need to have security rights in order to update correct?
My question is, will giving them these rights open up a security issue where it might be easier for them to use malicious code to change the script to get access to other areas of the database?