Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

why qlik sense generate min/max query in direct query?

I had a direct query script as below in data load editor.

DIRECT QUERY

DIMENSION

SESSION_ID as message_session_id

DETAIL

DEST_TYPE as dest_type,

MSG_SUMMARY as message_summary

FROM `customer_prod`.`messages`;

Then I created a table which has the columns in a sheet. When I reopen my app and open the sheet, qlik sense always send the following sql commands to database.


SELECT MIN(MSG_SUMMARY) FROM `customer_prod`.`messages`;

SELECT MIN(DEST_TYPE ) FROM `customer_prod`.`messages`


Because messages is a huge table, it takes more than 30 seonds to run the sql commands.


Why qlik sense generate min/max query in direct query? Could we disable the sqls?  becasue I think the sqls with min are not necessary.

1 Reply
Contributor
Contributor

does anybody have ideas to avoid to generae the scripts?