where clause in QlikView while fetching data from SAP DSO

[bhavik123]

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

[Anil_Babu_Samineni]

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?

[bhavik123]

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.

[Anil_Babu_Samineni]

Perhaps this?

DSO_NAME:

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

SQL Select (NoKey) Invoice_No,

                              CLEARING_DATE

from DSO_NAME;

[tamilarasu]

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;

[bhavik123]

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

[bhavik123]

Hi Anil,

It is giving syntax error.

[tamilarasu]

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;

[tamilarasu]

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;

OR

Load * ;

SQL Select (NoKey) Invoice_No,

                              CLEARING_DATE

from DSO_NAME

where  CLEARING_DATE '';

[bhavik123]

Thanks Tamil Nagaraj,

still no luck have tried preceding option as well.