topic Script problem when trying to filter data in QlikView

Script problem when trying to filter data

Fri, 29 Oct 2010 09:53:34 GMT

Dear fellow QV users;

I have an excel load. I would like to filter the data. The only problem is that the between function is not working. I get the following massage: garbage after statement. Could someone tell me what I am doing wrong.

With kind regards,

Aissam

JC:

LOAD

JOB_NUMBER,

BILL_CODE

FROM

[Data Dump\JobCost\Jobcost.xls] (biff, embedded labels, table is [Sheet1$])

WHERE

;

JOB_NUMBER <> '0' and BILL_CODE = '5.01' and JOB_NUMBER between '07D0000' and '12D8000'

Script problem when trying to filter data

Fri, 29 Oct 2010 10:02:24 GMT

hey,

function 'between' doesn't exist in QlikView. You should try '07D0000'<= JOB_NUMBER and JOB_NUMBER <= '12DXXXX'

Script problem when trying to filter data

Fri, 29 Oct 2010 10:20:40 GMT

It works,

Thanks very much.

With kind regards,

Aissam