SQL Filter

[mick1234]

Hi guys,

i am using qlik sense desktop, and used ole db to connect to our sql database, but i running sql script and load some data i figure out that would be good  to have some filters to select some new data from db instead of loading the whole database, for example:

Sql select ID, name, surname

from db

where some criteria

and instead of generate all criteria  i would like to put some data by hand from application layer, is that possible?

[jaimeaguilar]

Hi,

you can execute almost any sql command inside QlikView/Qlik Sense, just type this inside Qlik script:

TableName:

load *; //here you can use qlik syntax in case you want to add extra fields or make a modification to sql data

SQL Select a,b,c

from db_table

where  a = '5', etc etc

you can also store the result of your query in qvd, csv, txt to reuse it later,

hope this helps,

regads

[PabloTrevisan]

Hi Mykola,

take a look in this link:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/...

[mick1234]

thank for reply, my bad, i will try to be more specific, for example i get result from db, and DOES it possible to insert sql query using fields, master items, custom object or something else

[mick1234 · Accepted solution]

I was looking for a SQL procedure using in qlik, done