topic Re: Dynamic SQL query and display in App Development

Dynamic SQL query and display

Alotra — Fri, 17 Nov 2023 13:27:48 GMT

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

Re: Dynamic SQL query and display

vincent_ardiet_ — Fri, 17 Nov 2023 14:00:19 GMT

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-p/1711657

Re: Dynamic SQL query and display

Alotra — Fri, 17 Nov 2023 14:02:28 GMT

Thanks I will have a look to it !