Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rajubollimuntha
New Contributor

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
MVP
MVP

Re: SQL functions are not supporting

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

OmarBenSalem
Esteemed Contributor

Re: SQL functions are not supporting

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?

Community Browser