Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
[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.
[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.
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|*'
);
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|*');
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.