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