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: 
sushil353
Master II
Master II

where condition in load script

Hi All,

I am facing a very silly problem.. please check out the query given below, it is fetching 0 records in qlikview while the same query gives required result when runned in PL/SQL developer.

LOAD "TIME_ID",

    "TIME_DATE",

    "TIME_HOUR",

    "DAY_OF_MONTH",

    "WEEK_OF_YEAR",

    "WEEK_STARTING_DATE",

    "MONTH_OF_YEAR",

    "MONTH_NAME",

    QUARTER,

    "YEAR_OF_YEAR",

    "HALF_YEAR",

    "DAY_DATE",

    "ISO_YEAR";

SQL SELECT *

FROM "TIME_HR_DIM"

where "TIME_DATE >= '01-AUG-2011'

and "TIME_DATE" < '07-AUG-2011';

Thanks..

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   You have misses " at this position

 

   where "TIME_DATE >= '01-AUG-2011'

 

   Make sure that the format of date is same in the field.

   If its same then try this.

   LOAD "TIME_ID",

    "TIME_DATE",

    "TIME_HOUR",

    "DAY_OF_MONTH",

    "WEEK_OF_YEAR",

    "WEEK_STARTING_DATE",

    "MONTH_OF_YEAR",

    "MONTH_NAME",

    QUARTER,

    "YEAR_OF_YEAR",

    "HALF_YEAR",

    "DAY_DATE",

    "ISO_YEAR";

SQL SELECT *

FROM "TIME_HR_DIM"

where "TIME_DATE" >= Date(Date#('01-AUG-2011','DD-MMM-YYYY'),'DD-MMM-YYYY')

and "TIME_DATE" < Date(Date#('07-AUG-2011','DD-MMM-YYYY'),'DD-MMM-YYYY');

Regards,

Kaushik Solanki

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

LOAD "TIME_ID",

    "TIME_DATE",

    "TIME_HOUR",

    "DAY_OF_MONTH",

    "WEEK_OF_YEAR",

    "WEEK_STARTING_DATE",

    "MONTH_OF_YEAR",

    "MONTH_NAME",

    QUARTER,

    "YEAR_OF_YEAR",

    "HALF_YEAR",

    "DAY_DATE",

    "ISO_YEAR";

SQL SELECT *

FROM "TIME_HR_DIM"

where "TIME_DATE" >= '01-AUG-2011'

and "TIME_DATE" < '07-AUG-2011';

???