Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mall1m
Partner - Contributor III
Partner - Contributor III

execute SQL query using user's filters

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

Labels (3)
0 Replies