topic Re: where clause in QlikView while fetching data from SAP DSO in QlikView

where clause in QlikView while fetching data from SAP DSO

bhavik123 — Thu, 11 Jan 2018 05:29:24 GMT

Hi All,

I am trying to fetch the data from SAP DSO using SAP DSO connector. While fetching the data I want to fetch Invoice Clearing Date with blank value.

I have seen different options for where clause like EQ NE CP in QlikView SAP Connector manual but i am not sure how to utilise this option to fetch field with blank value.

Could you please some one help me on this?

Thanks & Regards,

Bhavik

Re: where clause in QlikView while fetching data from SAP DSO

Anil_Babu_Samineni — Thu, 11 Jan 2018 05:44:21 GMT

Let it be for SAP data like?

SAP Connection..

Here, you can use LOAD statement to convert into Qlikview

Load *;

Statement for load..

Note - Now, tell me what you want to do using Where condition here?

Re: where clause in QlikView while fetching data from SAP DSO

bhavik123 — Thu, 11 Jan 2018 05:50:58 GMT

Hi Anil,

DSO_NAME:

Laod * ;

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME

where CLEARING_DATE I EQ NULL;

What I am looking for:

in the where clause i want to mention CLEARING_DATE is blank. Not sure with the syntax.

Re: where clause in QlikView while fetching data from SAP DSO

Anil_Babu_Samineni — Thu, 11 Jan 2018 05:53:12 GMT

Perhaps this?

DSO_NAME:

Laod * CLEARING_DATE = '' or IsNull(CLEARING_DATE);

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME;

Re: where clause in QlikView while fetching data from SAP DSO

tamilarasu — Thu, 11 Jan 2018 06:02:48 GMT

Hi Bhavik,

For Null Values:

DSO_NAME:

Laod * ;

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME

where CLEARING_DATE IS NULL;

For Non-null Values:

DSO_NAME:

Laod * ;

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME

where CLEARING_DATE IS NOT NULL;

Re: where clause in QlikView while fetching data from SAP DSO

bhavik123 — Thu, 11 Jan 2018 08:13:11 GMT

Hi Tamil Nagaraj,

It is giving script error.

I am using SAP DSO Connector for connection with SAP BW may be because of this it is not recognizing IS NULL statement.

Thanks,

Bhavik

Re: where clause in QlikView while fetching data from SAP DSO

bhavik123 — Thu, 11 Jan 2018 08:32:11 GMT

Hi Anil,

It is giving syntax error.

Re: where clause in QlikView while fetching data from SAP DSO

tamilarasu — Thu, 11 Jan 2018 08:34:50 GMT

Hi Bhavik,

I have not used SAP DSO connector before. But you can try preceding load as suggested by Anil.

DSO_NAME:

Load * where IsNull(CLEARING_DATE) ;

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME;

Re: where clause in QlikView while fetching data from SAP DSO

tamilarasu — Thu, 11 Jan 2018 08:47:12 GMT

I am not sure but worth to try,

DSO_NAME:

Load * ;

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME

where CLEARING_DATE IS INITIAL;

Load * ;

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME

where CLEARING_DATE '';

Re: where clause in QlikView while fetching data from SAP DSO

bhavik123 — Thu, 11 Jan 2018 09:08:08 GMT

Thanks Tamil Nagaraj,

still no luck have tried preceding option as well.

Re: where clause in QlikView while fetching data from SAP DSO

Anil_Babu_Samineni — Thu, 11 Jan 2018 09:12:54 GMT

Can u tell me exactly what you want to do with Where condition?

Re: where clause in QlikView while fetching data from SAP DSO

bhavik123 — Thu, 11 Jan 2018 09:39:09 GMT

Hi Anil,

I want to fetch only those INVOICE_NO against which there is no CLEARING_DATE.

For this in where clause i want to mention CLEARING DATE as blank or null.

Re: where clause in QlikView while fetching data from SAP DSO

tamilarasu — Thu, 11 Jan 2018 09:47:05 GMT

Hi Bhavik,

This should work. If not, please post snapshot of your SAP data.

DSO_NAME:

Load * Where Len(Trim(CLEARING_DATE))=0 ;

SQL Select (NoKey) Invoice_No,

CLEARING_DATE

from DSO_NAME;