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

[Anonymous]

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.

[zebhashmi]

try through Load statement may be some syntax if conflicting.

[devarasu07]

Hi,

It should work, can u share they query?

[calvin_wee]

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