Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_CODEFROM
[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'hey,
function 'between' doesn't exist in QlikView. You should try '07D0000'<= JOB_NUMBER and JOB_NUMBER <= '12DXXXX'
hey,
function 'between' doesn't exist in QlikView. You should try '07D0000'<= JOB_NUMBER and JOB_NUMBER <= '12DXXXX'
It works,
Thanks very much.
With kind regards,
Aissam