Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

how to create a SQL Statement with two subquery level

Hi there,

I'm using the QVOlapConnetor and the QVSapQueryConnector and I would like the create a SQL statement with two level of subqueries.

For example:

Select C

From T1

where A IN (

Select A From T2 where B IN (

Select B From T3

)

)

It seems to work fine just for one level subselect.

Any Suggestion?

Thanks a lot in advance

2 Replies
martin59
Valued Contributor II

Re. :how to create a SQL Statement with two subquery level

Hi,

Hope it helps you


T3:
LOAD B;
SQL SELECT B FROM T3;
T2:
LEFT KEEP (T3)
LOAD A, B;
SQL SELECT A, B FROM T2;
T1:
LEFT KEEP (T2)
LOAD A, C;
SQL SELECT A, C FROM T1;

DROP TABLE T2, T3;
DROP FIELD A;


Not applicable

Re. :how to create a SQL Statement with two subquery level

thanks Martin, but the problem is that I need to limit the dataset at SAP Side because the dataset is very huge and then I can't load the data in QV and after perform a left keep so my question is about how to send a SQL Statement to SAP but I don't know the right syntax to apply (is not SQL standard nor SQL Oracle)

Community Browser