1 Reply Latest reply: Mar 9, 2017 8:39 AM by Vladimir Komarov RSS

    Regarding Sql statements running in qlik sense

    Srujana Nunna

      Hi Team,

       

      Am New to qlik sense, As of now am connect to data source(development  Instance) .Am writing the queries in section

       

      LIB CONNECT TO 'HMDEV';

      LOAD *;

      SQL SELECT * FROM EMPLOYEE_INFO;

       

      But am not getting any data from EMPLOYEE_INFO table, I didn't know how to run the SQL statement in qlik sense.in SQL developer we ran the sql statement using ctrl+enter or F5 like this. But in qlik sense I dint get.

       

      Actually my requirement is we are writing one query ,we export to result of the query.

       

      Please help me on this.

       

      Thanks,

      Srujana.

        • Re: Regarding Sql statements running in qlik sense
          Vladimir Komarov

          Srujana,


          Your SQL / Load code looks ok.


          Check if your CONNECT command is working properly. Do you the "HMDEV" data connection setup properly?

          Check the logs, you should see the following in Output window in DEBUG mode:


          Connecting to HMDEV

          Connected


          If not, check that this connector has all users who can access it specified...


          Regards,

          Vlad

           


          P.S. When applicable, please mark this answer Correct or Helpful.