Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

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

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,

1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
micheledenardi
Specialist II
Specialist II

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
suvechha_b
Creator III
Creator III
Author

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
Specialist II
Specialist II

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|*');

 

 

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
suvechha_b
Creator III
Creator III
Author

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.