Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

SQL script to load in Qlik

Hi Experts,

Can any one please help me to load below block of SQL script in Qlik.

Is it possible to load the below script as it is in Qlik by adding SQL connection on top or do we need to make any syntax changes.

Thanks in advance

1 Reply
Master II
Master II

You should be able to load that directly

You will need to create your SQL connection as a data connection and select this before your load statement.

I would check your field aliases as there seems to be some there with no space between AS and the alias name.

I'd also create a view if you have the rights to in the database to keep the script cleaner.

Also id give your fields more user friendly names for use in your qlik app.

Any flag fields with an _<flagname> and keys starting with an %<keyname>.

Hope this helps