Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
suryaa30
Contributor II

Exclude Data using not equal to in Qlikview Script

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

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Exclude Data using not equal to in Qlikview Script

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;

3 Replies
vishsaggi
Esteemed Contributor III

Re: Exclude Data using not equal to in Qlikview Script

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;

Highlighted
suryaa30
Contributor II

Re: Exclude Data using not equal to in Qlikview Script

Thanks Vishwarath

vishsaggi
Esteemed Contributor III

Re: Exclude Data using not equal to in Qlikview Script

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