Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change load statement to get correct date values?


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.

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Try this.

TblData:

LOAD ID,

    name,

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

SQL SELECT *

FROM tblData

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

7 Replies
deepakqlikview_123
Specialist
Specialist

Hi,

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

Thanks

Yousef_Amarneh
Partner - Creator III
Partner - Creator III

TblData:

LOAD ID,

    name,

    Dateentered

SQL SELECT *

FROM tblData

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

Yousef Amarneh
Not applicable
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Try this.

TblData:

LOAD ID,

    name,

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

SQL SELECT *

FROM tblData

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ashfaq_haseeb
Champion III
Champion III

Hi,

Try below

LOAD ID,

    name,

    Dateentered

SQL SELECT *

FROM tblData

where Year(Dateentered) <>1899;

Regards

ASHFAQ

Not applicable
Author

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

Not applicable
Author

Thanks.