To configure JethroODBC for use with Qlik Sense:
It is recommended to add the following line to the loading script of each Qlik app:
SET Verbatim = 1;
The variable helps to make sure that Qlik won't trim spaces from values within filters.
To enable Set analysis support in Jethro, log into the Linux machine on which Jethro server is installed as user 'jethro', and add the following two lines to the bottom of the file /opt/jethro/instances/<your-instance-name>/local-conf.ini:
Save the file, and then, run the command:
service jethro restart
To be able to execute Set Analysis expressions in a Direct Discovery mode, please read the workaround suggested by Jethro under the Qlik functions page.