Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

does anybody have ideas to avoid to generae the scripts?