topic Re: Exclude Data using not equal to in Qlikview Script in QlikView

Exclude Data using not equal to in Qlikview Script

suryaa30 — Mon, 03 Jul 2017 14:37:11 GMT

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

Re: Exclude Data using not equal to in Qlikview Script

vishsaggi — Mon, 03 Jul 2017 14:41:34 GMT

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;

Re: Exclude Data using not equal to in Qlikview Script

suryaa30 — Mon, 03 Jul 2017 14:43:24 GMT

Thanks Vishwarath

Re: Exclude Data using not equal to in Qlikview Script

vishsaggi — Mon, 03 Jul 2017 14:58:05 GMT

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