topic SAP Date filter in QlikView

SAP Date filter

Anonymous — Tue, 30 Jun 2015 11:10:14 GMT

Hi All,

I have connection setup and have to filter the data based on date column.

Format is YYYYMMDD when i am trying to filter it in Script either it is not filtering or throwing an error.

Any suggestion?

Thanks

Manish Madan

Re: SAP Date filter

robert_mika — Tue, 30 Jun 2015 11:40:09 GMT

Could you post your data/ Errors/expression you are using?

I guess you need to use Date# or Date to bring the data into correct format.

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 13:43:52 GMT

Data format in SAP is YYYYMMDD i have updated the Qlikview format as well.

Now it is same as SAP.

while extracting the data from SAP i am adding conditiona as

STRTDATE>= 20150131;

then, it starts extraction but doing full load rather than loading data Feb onwards.

Thanks

Manish

Re: SAP Date filter

robert_mika — Tue, 30 Jun 2015 13:47:35 GMT

Attached an extract.

Maybe what you got is a Text not Date and Qlikview can not fetch your data as you wish.

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 13:57:11 GMT

Try this

>= '20150131'

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:05:16 GMT

I use SAP tables daily using this filter logic

Let me know the table name if this doesn't work

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:12:43 GMT

Table name = TBTCO

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:13:14 GMT

column name STRTDATE

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:22:26 GMT

did you tried that date format?

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:26:23 GMT

yes, got the error message.

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:28:59 GMT

sorry wrong screenshot,.missing where

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:30:48 GMT

I tried it ...when i am adding that condition in script it runs but it extracts the full data instead of 5 months data.

Re: SAP Date filter

Anonymous — Tue, 30 Jun 2015 14:31:54 GMT

can you send me the complete script you are using?