I have an app which extracts data from our ERP system. From/to date is a main key here and I would like the user to be able to put in whatever start date and end date they would like.
The sql now is something like .....where date between 20240101 and 20240630 - in Excel you can solve it by creating a parameter(?) in the sql and link that to specific cells where the user can change, but can you do something similar in Qlik like two input boxes or ? Key is that the user input flows directly into the load sql and then runs based on the user input.
In QlikView exists an Input() feature within the script: System functions | QlikView Help but AFAIK it isn't available within Sense.
Beside this the users may add their dates in an Excel and those values are read and assigned to variables before the sql is performed and there applied in the where-clause. If the data-set isn't too large such pre-loaded data might be also used within a where exists(Date) clause or for an inner join filtering.
