Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! 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;

suryaa30
Contributor II

Re: Exclude Data using not equal to in Qlikview Script

Thanks Vishwarath

Highlighted
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.