Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding Sql statements running in qlik sense

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.

1 Reply
vlad_komarov
Partner - Specialist III
Partner - Specialist III

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.