Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi Mykola,
take a look in this link:
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