Script problem when trying to filter data

[#1]

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'

[#2 · Accepted solution]

hey,

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

[#3]

It works,

Thanks very much.

With kind regards,

Aissam