Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
omyahamburg
Contributor II

How to exclude a value range from loading in script

Hello everybody

In my script I load one field with a range of values:

e.g.

Field 1

1398005

1400001

1400002

1400003

1400004

1400004/01

1400005

1400006

1400007

1400008

1400009

1400010

1401009/1

1401009

1474385

2453474

2773319

8447565

9354793

9703607

How can I set in the script, that values 1400001-1401009 will be excluded, but 1400004/01 + 1401009/1 will be loaded together with all other values ?

Thanks for your help.

5 Replies
Not applicable

Re: How to exclude a value range from loading in script

Hi,

Just write sql statement in the script It works

example:

SQL SELECT NAme,Roll

FROM Supriya.dbo.Customer WHERE Roll NOT BETWEEN 9 AND 99 ;

Thanks,

Supriya

deepakk
Valued Contributor III

Re: How to exclude a value range from loading in script

hi,

You can try out the method used in the application.

There might be easier ways but at the moment I can think only  of this

Deepak

omyahamburg
Contributor II

Re: How to exclude a value range from loading in script

Hi,

thank you, in my script WHERE [Field 1] NOT BETWEEN... does not work.

[Table2]:

load [Field 1]

    

Resident Table1;

DROP Table1;

omyahamburg
Contributor II

Re: How to exclude a value range from loading in script

Hi Deepak

That looks great, thanks a lot, I will try it.

Joerg

Not applicable

Re: How to exclude a value range from loading in script

Hi,

Try using

[Field 1]< 1400001 AND [Field 1]> 1400009

Hope this helps.

BR, Neha

Community Browser