Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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;

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;

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.