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: 
Anonymous
Not applicable

SQL functions are not supporting

Hi,

I am trying to use SQL Query of existing application in my Qlik sense data load editor which will get the data from Oracle DB. It is huge query which has lot of joins and functions.

Qlik sense is not loading data until remove SQL functions like to_char. Please let me know, can we use SQL Query AS IS or we need to convert into Qlik sense compatible. Thanks in advance.

2 Replies
swuehl
MVP
MVP

Can you post your script snippet? Can you run the same SELECT statement from another DB client?

OmarBenSalem

when u load data from an sql database u'll have sthing like this:

load

col1,

col2,

...

coln

select

col1,

col2,

...

coln

from yourSource;

in the load part, u can use QLIK's FUNCTIONS; in the SELECT part, u can use the SQL Functions relative to ur database.

Hope that was clear?