How to write script where field is not equal to some values .

[suvechha_b]

Hi All ,

How to write in qliksense script where RECORD_SOURCE_KEY is not equal to

'102.41' ,

'102.13',

'102.33',

'102.41'

[RECORD_SOURCE]:
LOAD * FROM 'lib://QlikData/Model_RecordSources.qvd' (qvd)
where
not "RECORD_SOURCE_KEY" like '102.41'
or not "RECORD_SOURCE_KEY" like '102.13'
or not "RECORD_SOURCE_KEY" like '102.33'
or not "RECORD_SOURCE_KEY" like '102.42';

Regards,

[micheledenardi · Accepted solution]

[RECORD_SOURCE]:
LOAD * FROM 'lib://QlikData/Model_RecordSources.qvd' (qvd)
where not match(RECORD_SOURCE_KEY,'102.41','102.13','102.33','102.42');

In alternative use Exists() Function (suitable if you have lots of values to exclude) from your final table.

[suvechha_b]

Thanks , Please kindly assist if I got something like this Policy_key not like
('102.13|*' ,
'102.42|*'
,'102.13|*'
,'102.41|*'
);

The below script is not working : -

[POLICY]:
LOAD
"POLICY_KEY",
"POLICY_NUMBER"
from 'lib://QlikData/Model_Policies.qvd' (qvd)
Where Not Match(POLICY_KEY,
'102.13|*'
,'102.42|*'
,'102.13|*'
,'102.41|*'
);

[micheledenardi]

Use Wildmatch() function.

[POLICY]:
LOAD
"POLICY_KEY",
"POLICY_NUMBER"
from 'lib://QlikData/Model_Policies.qvd' (qvd)
Where not wildmatch(POLICY_KEY,'102.13|*','102.42|*','102.13|*','102.41|*');

[suvechha_b]

Hi ,

I used the below script for like -

LOAD * FROM 'lib://QlikData/Model_RecordSourceProducts.qvd' (qvd)
where
not RECORD_SOURCE_PRODUCT_KEY like '102.13|*'
and not RECORD_SOURCE_PRODUCT_KEY like '102.33|*'
and not RECORD_SOURCE_PRODUCT_KEY like '102.41|*'
and not RECORD_SOURCE_PRODUCT_KEY like '102.42|*'

And it worked.