Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Script problem when trying to filter data

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'







1 Solution

Accepted Solutions
Highlighted
Not applicable

Script problem when trying to filter data

hey,

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

View solution in original post

2 Replies
Highlighted
Not applicable

Script problem when trying to filter data

hey,

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

View solution in original post

Highlighted
Not applicable

Script problem when trying to filter data

It works,

Thanks very much.

With kind regards,

Aissam