execute SQL query using user's filters

mall1m — Sat, 16 Nov 2024 18:04:48 GMT

Dear All,
I’m trying to find a way to execute an SQL query that will uses my user filter
A (simple) example:
my user will select a start date and a category and the first line of my result table will the first item (A) that will fit into an interval from my start date
then I will use the start date from my (A) item to determine which item will be the next correct result, and so on

I have no possibility to precalculate any data as the result will vary depending on user selection

I tried to use set analysis but it appears to be highly complex

Another team on different technology manage to create a stored procedure that do the job
Is there a way to execute this stored procedure from qlik sense with the content of my user filter ?

i searched for write back extension but it doesn't seem to fit my needs

thanks in advance for any help/idea

topic execute SQL query using user's filters in App Development

execute SQL query using user's filters