Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mick1234
Contributor II
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
Contributor II
Contributor II
Author

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

View solution in original post

4 Replies
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

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

mick1234
Contributor II
Contributor II
Author

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

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