QlikView SQL Select for SAP where Value is in other Table

qlikviewalex — Mon, 07 Dec 2015 10:00:38 GMT

Hello,

I load data from SAP in QlikView.

Table1:

SQL Select

KNUMH,

...

from A004

where DATAB <= '$(vdateToDay)' and .............. ;

This part works well.

Now I'd like to add an other table. But only if the key "KNUMH" have the same value.

So I use a left join.

left join (Table1)

SQL select MANDT,

KNUMH,

...

from KONP;

This works but not very fast, because in KONP are 100 000 000 records and it load all records before the left join reduced the values. In Table1 I had the same problem, but after I add the "Where"-filter it works well.

Now I like to Select only the records where KNUMH is in Table1.

I try this way and some variants I find in the community:

SQL select MANDT,

KNUMH,

...

from KONP where and KNUMH in (Select KNUMH FROM Table1);

But it doesn't work. I like to use Table1 for the selection, because Table1 is filtered.

Thank you for your support.

Regards

Alex

Re: QlikView SQL Select for SAP where Value is in other Table

qlikviewalex — Fri, 05 Aug 2016 10:19:34 GMT

KONP:

sql subselect

KNUMH

KOPOS

KAPPL

KSCHL

KRECH

KBETR

KPEIN

KMEIN

from KONP

where KNUMH in (select KNUMH from A004 where DATAB <= '$(vdateToDay)');

topic QlikView SQL Select for SAP where Value is in other Table in QlikView

QlikView SQL Select for SAP where Value is in other Table

Re: QlikView SQL Select for SAP where Value is in other Table