Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try through Load statement may be some syntax if conflicting.
Hi,
It should work, can u share they query?
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