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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Alotra
Contributor
Contributor

Dynamic SQL query and display

Hello everyone,

I'm new to Qlik Sense Enterprise, and would like to create an application, for which I would need, based on the user filters selection, to run a SQL query with choices as column name, and then display in a table the data obtained through the query. So here are the problems: 

- The query needs to be based on the choice of the user

- The number of column to display into the table will be different from one query to the user

If someone could help me through it, I would be really glad.

 

Thanks in advance

Labels (1)
2 Replies
vincent_ardiet_
Specialist
Specialist

You should have a look to the ODAG feature, this is not straight forward but this is matching your expectation I think.
https://community.qlik.com/t5/Official-Support-Articles/How-to-Create-On-Demand-Applications-ODAG/ta...

Alotra
Contributor
Contributor
Author

Thanks I will have a look to it !