Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

swamymns
New Contributor

select statement not fetching the data in Qlik sens though connection is good

hi all,

am new to the Qlik Sense desktop. am unable to select the data from the database table even though connection exits.

i could able to fetch all 4 column data from Oracle developer but same is not returning in Qlik Sense.

FYI: am using concatenated select statements in one single select query.

Please help.

3 Replies
zebhashmi
Valued Contributor

Re: select statement not fetching the data in Qlik sens though connection is good

try through Load statement may be some syntax if conflicting.

devarasu07
Honored Contributor II

Re: select statement not fetching the data in Qlik sens though connection is good

Hi,

It should work, can u share they query?

calvin_wee
New Contributor III

Re: select statement not fetching the data in Qlik sens though connection is good

Very likely it is the WHERE condition. Check the data type such as Date or special characters.

TOAD/SQL Developer somehow is able to handle when type is different but content is ok.

e.g. WHERE SOME_DATE>SYSDATE

If SOME_DATE is character but follows date format, may not work in QlikSense but will work in SQL Developer or TOAD.

Hope this helps

Community Browser