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

Anonymous — Wed, 15 Aug 2018 01:47:43 GMT

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.

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

Anonymous — Mon, 03 Sep 2018 07:50:55 GMT

does anybody have ideas to avoid to generae the scripts?

topic why qlik sense generate min/max query in direct query? in App Development

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

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