Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Unable to load table with WHERE condition on data field...pls help

Hi all,

I have the following load script:

.......

SET TimestampFormat='DD-MM-YYYY';

.......

LOAD

My problem is:

If i load the table without the WHERE condition, my EVENT_DATE field is in corect format (DD-MM-YYYY).

After I put the WHERE condition, EVENT_DATE transforms to numeric format (ex: 38270)...and my WHERE condition is not working...but I don't receive any error in executing the script.

I wold like to give the condition for loading my table where EVENT_DATE>'01-01-2011' and the EVENT_DATE field format to remain the same...

Thanks a lot!

CLAIM_ID,

CLAIM_REGID,

CLAIM_STARTED,

EVENT_DATE,

INSR_TYPE FROM

EVENT_DATE > '01-01-2011';

WHERE

1 Solution

Accepted Solutions
Not applicable

Unable to load table with WHERE condition on data field...pls help

The possible solution still applies:


CLAIM_ID,

CLAIM_REGID,

CLAIM_STARTED,

EVENT_DATE,

INSR_TYPE

FROM

WHERE date(EVENT_DATE, 'DD-MM-YYYY') > '01-01-2011';

4 Replies
Not applicable

Unable to load table with WHERE condition on data field...pls help

Hi Sandries,

Try have you tried adding a date format i.e. :

date(EVENT_DATE, 'DD-MM-YYYY') > '01-01-2011' ....

Not applicable

Unable to load table with WHERE condition on data field...pls help

Sorry for the inconvenience of my post...It should look like:

Hi all,


I have the following load script:

.......

SET TimestampFormat='DD-MM-YYYY';
.......

LOAD


CLAIM_ID,

CLAIM_REGID,

CLAIM_STARTED,

EVENT_DATE,

INSR_TYPE

FROM

WHERE EVENT_DATE > '01-01-2011';

My problem is:

If i load the table without the WHERE condition, my EVENT_DATE field is in corect format (DD-MM-YYYY).

After I put the WHERE condition, EVENT_DATE transforms to numeric format (ex: 38270)...and my WHERE condition is not working...but I don't receive any error in executing the script.

I would like to give the condition for loading my table where EVENT_DATE>'01-01-2011' and the EVENT_DATE field format to remain the same...

Thanks a lot!

Not applicable

Unable to load table with WHERE condition on data field...pls help

The possible solution still applies:


CLAIM_ID,

CLAIM_REGID,

CLAIM_STARTED,

EVENT_DATE,

INSR_TYPE

FROM

WHERE date(EVENT_DATE, 'DD-MM-YYYY') > '01-01-2011';

Not applicable

Unable to load table with WHERE condition on data field...pls help

Very nice solution.

Thank's a lot!

Community Browser