topic Re: <> not working for the SQL statement in QlikView

<> not working for the SQL statement

NikhilSandavekarCP — Sat, 16 Nov 2024 17:41:57 GMT

i am trying to extract order which doesnt have rejection code which are '62' and 'CC'

i tried using the same in SQL statement but not able to get the filtered data

Below is my code :

[/BIC/ACS_NA_C2_1]:
LOAD
[SALESORG] as [Sales Org],
[/BIC/ORD_IT_QT] as [Order-Item Qty],
[DLV_QTY] as [Delivery Qty],
[/BIC/ZCALMNTHG] as [Calendar Month],
[/BIC/ZCALYEARG] as [Calendar Year];

SQL Select SALESORG,/BIC/ORD_IT_QT, DLV_QTY, /BIC/ZCALMNTHG, /BIC/ZCALYEARG from /BIC/ACS_NA_C2 WHERE SALESORG = 'US01' and /BIC/ZCALMNTHG = '$(CurrMonth)' and /BIC/ZCALYEARG = '$(CurrYear)' and /BIC/ABGRU <> 'CC' or /BIC/ABGRU <> '62';

Re: <> not working for the SQL statement

Taoufiq_Zarra — Wed, 16 Dec 2020 08:24:44 GMT

@NikhilSandavekarCP have you tested ?

and ( /BIC/ABGRU <> 'CC' or /BIC/ABGRU <> '62')

Re: <> not working for the SQL statement

NikhilSandavekarCP — Wed, 16 Dec 2020 08:33:03 GMT

Hello Taoufiq,

I tried the same before but didnt work for me

Re: <> not working for the SQL statement

Taoufiq_Zarra — Wed, 16 Dec 2020 08:42:36 GMT

@NikhilSandavekarCP and ?

[/BIC/ACS_NA_C2_1]: LOAD [SALESORG] as [Sales Org], [/BIC/ORD_IT_QT] as [Order-Item Qty], [DLV_QTY] as [Delivery Qty], [/BIC/ZCALMNTHG] as [Calendar Month], [/BIC/ZCALYEARG] as [Calendar Year], [/BIC/ABGRU] where Match([/BIC/ABGRU],'CC','62')=0; SQL Select SALESORG,/BIC/ABGRU,/BIC/ORD_IT_QT, DLV_QTY, /BIC/ZCALMNTHG, /BIC/ZCALYEARG from /BIC/ACS_NA_C2 WHERE SALESORG = 'US01' and /BIC/ZCALMNTHG = '$(CurrMonth)' and /BIC/ZCALYEARG = '$(CurrYear)';

Re: <> not working for the SQL statement

NikhilSandavekarCP — Wed, 16 Dec 2020 08:59:31 GMT

Thanks a lot that worked like a Charm!!!

Re: <> not working for the SQL statement

MayilVahanan — Wed, 16 Dec 2020 09:13:35 GMT

HI @NikhilSandavekarCP

Try with not in

/BIC/ABGRU not in ('CC','62');