To achieve the attched objective i'm using following query but its not working; Giving error subselect not allowed on more than two table

[#1]

[#2]

Can you show your load script ?

Thanks

[#3]

SQL subselect MEINS MANDT MENGE BELNR BUDAT PEINH NETWR MATKL UEBTK UEBTO KALNR KLVAR PERNR MWSKZ TXJCD SDATE KNOBJ PACKNO KSTAR RANG MOLGA VRTKZ TWRKZ ALTERNAT ENDTIME DEL NAVNW SRVPOS INTROW LGART PERSEXT STOKZ STELL LBNUM AUSGB STLVPOS IWEIN FORMELNR CHGTEXT TAXTARIFFCODE LGTXT IFTNR INSDT EXTERNALID BRTWR BEGTIME SPINF TOPOS ACT_MENGE ACT_WERT INV_MENGE EXTROW EXTGROUP PACKAGE SUB_PACKNO EXTSRVNO WITH_LIM FROMPOS KTEXT1 PLN_PACKNO PLN_INTROW KNT_PACKNO KNT_INTROW TMP_PACKNO TMP_INTROW STLV_LIM LIMIT_ROW KNT_WERT KNT_MENGE ZIELWERT UNG_WERT UNG_MENGE ALT_INTROW BASIC BIDDER SUPPLE FREEQTY INFORM PAUSCH EVENTUAL PRS_CHG TBTWR BASWR KKNUMV INT_WORK ACT_WORK MAPNO SRVMAPKEY CATSCOUNTE FRMVAL1 FRMVAL2 FRMVAL3 FRMVAL4 FRMVAL5 USERF1_NUM USERF2_NUM USERF1_TXT USERF2_TXT EXTREFKEY PER_SDATE PER_EDATE  from ESLL

where SUB_PACKNO IN (select SUB_PACKNO FROM ESLL where PACKNO IN (select PACKNO FROM ESSR where ERDAT >= '$(FDate)' and ERDAT <= '$(TDate)'));

[its_anandrjs]

Load your tables like below

T:

LOAD * Inline

[

serviceEntry,Package,Date

0001,1000,01.01.2012

0002,2000,02.02.2012

0003,3000,03.03.2014

];

Left Join

LOAD * Inline

[

Package,Subpackage

1000,1001

2000,2001

3000,3001

];

Left Join

LOAD * Inline

[

Subpackage, Line items

1001,10

1001,20

2001,10

3001,10

3001,20

];

NoConcatenate

LOAD * Resident T

Where Right(Date,2) = 12;

DROP Table T;

If date in not in date format for this it is used.

Hope this helps

[#5]

If I'm being honest, I'd load the queries as 2 individual tables within Qlikview, and then let Qlikview make the connections on the keys above.

ESLL:

sql select *

from  esll;

ESSR:

SQL select * from ESSR;

you can then do the calculations from within Qlikview

[#6]

i have also loaeded them as separate tables and keys have been defined. The problem is i want to restrict amount of data from ESLL table to be loaded  based on the date in ESSR table; just to minimize the data fetching time.

[#7]

dear,

the table entries are just sample entries. I am picking up data from SAP tables via SAP connector..

[its_anandrjs]

Ok from SAP connector make a QVD of the tables then when you get this in qlikview make association with the tables or make joins between then or make a single table based on the keys.

Let me know

Hope this helps

Thanks & Regards

[its_anandrjs]

Which data you want to restrict from table and what is field name.

Thanks & Regards

[#10]

I want to get only those Subpacks and line items from ESLL_line for which entry sheet was created in year 2012 from table ESSR