Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL Zero Output when same table referenced twice

Hi All,

I am facing a very strange issue with Qlikview. The Query which runs fine in SQL developer and generated results, gives No results when triggered from Qlikview.

One thing which I found is it is because of the same table referenced twice in the Query which is causing issue.

EG:

select A.ACC, A.PARENT_ID, B.CHILD_ID

from CLASS AS A, CLASS AS B, RELATION

where A.ID= RELATION.PARENT_ID and

RELATION.CHILD_ID = B.ID

Note: Query works fine on SQL developer and other reporting tools

Could somebody please help.

0 Replies