topic Between function in where clause+load csv file in QlikView

Between function in where clause+load csv file

Fri, 25 Feb 2011 09:13:43 GMT

Hi,

I have a load statement and my problem is that when I load a csv file, the Between And statement in my where clause are treated as garbage..

is there any other way so that I can use date range in my script..

Here's the script:

LOAD [User ID],

[First Name],

[Last Name],

Department,

date(date#(Date,'YYYY/M/D')) as LogDate,

Time,

Event,

Terminal,

Remark

FROM

\\Phoenix\Qlik\report.csv

(txt, utf8, embedded labels, delimiter is ',')

Where Date Between $(vFromDate) AND Date <= $(vToDate);

maneshkhottcpl — Fri, 25 Feb 2011 09:58:23 GMT

Hi,

You cannot use the between function in load statement, it is belongs to SQL.

instead of it u can use AND statements.

Fri, 25 Feb 2011 11:53:05 GMT

as manesh said true...

u can use the where clause to load the data as like

Where Date >= $(vFromDate) AND Date <= $(vToDate);

Where Date >= '$(vFromDate)' AND Date <= '(vToDate)'

Wed, 12 Oct 2011 02:53:33 GMT

I tried that. but throwing error about Date and Varchar conversion issue.

Wed, 12 Oct 2011 02:54:15 GMT

I tried that. but throwing error about Date and Varchar conversion issue.

Mon, 21 Nov 2011 04:14:02 GMT

Atlast I have resolved my issue . The script goes like this:

Where (modifiedTimeStamp >= {d '$(StartDate)'} AND modifiedTimeStamp < {d '$(EndDate)'});

The Script works.