Exclude Data using not equal to in Qlikview Script

[suryaa30]

I have a field Code with numbers

Code

1563

1523

1600

1612

1456

I need to exclude records while loading in qlikview script that have value greater than or equal to 1600. what need to be written in where condition.

Code

1563

1523

1456

[vishsaggi · Accepted solution]

You mean less than 1600? Your question says greater than or equal to?

May be this?

LOAD * INLINE [

Code

1563

1523

1600

1612

1456

] Where Code < 1600;

[suryaa30]

Thanks Vishwarath

[vishsaggi]

Did it work? Can you close  the thread if it answered your question.