Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mick1234
New Contributor II

SQL Filter

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?

1 Solution

Accepted Solutions
mick1234
New Contributor II

Re: SQL Filter

I was looking for a SQL procedure using in qlik, done
4 Replies
jaimeaguilar
Valued Contributor II

Re: SQL Filter

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
Contributor II

Re: SQL Filter

Highlighted
mick1234
New Contributor II

Re: SQL Filter

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

Untitled.png

mick1234
New Contributor II

Re: SQL Filter

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