0 Replies Latest reply: Aug 28, 2015 7:10 AM by Barathi Krishnamurthy RSS

    Direct Data Discovery in Qlik Sense

      Hi,

      I am new to the world of Qlik Sense. I have been trying to implement direct data discovery.

       

      This is my code:

       

      IOT:

      DIRECT QUERY

      DIMENSION

      location,

      parameter,

      unit

      MEASURE

      `sensor_id`,

      `sampling_time`,

      val

      FROM `iot_db`.`sensor_data`;

       

       

      This is the odbc connection link name : LIB CONNECT TO 'iotDb (xor-ind_finance_eis)' (This is tested)

       

      This is set parameter I have added:  SET DirectIdentifierQuoteChar='``';

      The database is MySql. This does not reflect Creation of new entry immediately until I manually load it.
      I don't want to use the server scheduler and incremental load. Is this possible? Please help.