topic Re: How to change load statement to get correct date values? in QlikView

How to change load statement to get correct date values?

Thu, 07 Aug 2014 09:24:46 GMT

Hi,

I have a Dateentered with values 01/01/2011 to 07/08/2014. there is one value 21/08/1899. because of this value the fiscal year is showing values from 1899,1900,1901,1902....2014.

how to write a script to load qvd with out this value.

TblData:

LOAD ID,

name,

Dateentered

SQL SELECT *

FROM tblData

how to change above load statement.

Please can anyone suggest me.

Thanks.

Re: How to change load statement to get correct date values?

deepakqlikview_123 — Thu, 07 Aug 2014 09:27:35 GMT

Hi,

While creation of QVD u have to use some filters and conditions for avoiding the value.

Thanks

Re: How to change load statement to get correct date values?

Yousef_Amarneh — Thu, 07 Aug 2014 09:31:44 GMT

TblData:

LOAD ID,

name,

Dateentered

SQL SELECT *

FROM tblData

where Year(Dateentered) not in (1899,1900,1901,1902);

Re: How to change load statement to get correct date values?

Thu, 07 Aug 2014 09:56:43 GMT

Thanks. I tried it but still showing same years. Is there anyway to change this? Please suggest

Re: How to change load statement to get correct date values?

kaushiknsolanki — Thu, 07 Aug 2014 09:58:24 GMT

HI,

Try this.

TblData:

LOAD ID,

name,

if(Dateentered= '21/08/1899',null(),Dateentered) as Dateentered

SQL SELECT *

FROM tblData

Regards,

Kaushik Solanki

Re: How to change load statement to get correct date values?

ashfaq_haseeb — Thu, 07 Aug 2014 10:00:24 GMT

Hi,

Try below

LOAD ID,

name,

Dateentered

SQL SELECT *

FROM tblData

where Year(Dateentered) <>1899;

Regards

ASHFAQ

Re: How to change load statement to get correct date values?

Thu, 07 Aug 2014 10:14:05 GMT

Hi,

TblData:

LOAD ID,

name,

Dateentered

SQL SELECT *

FROM tblData

where date(Dateentered, 'DD/MM/YYYY') > date('01/01/1900', 'DD/MM/YYYY')

Hope it will help

Augustin

Re: How to change load statement to get correct date values?

Thu, 07 Aug 2014 10:18:25 GMT

Thanks.