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

View solution in original post

3 Replies
Highlighted
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;

View solution in original post

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