Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 (1)
0 Replies