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.
