Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Partner
Partner

Re: Regarding Sql statements running in qlik sense

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.