script help

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

HI all , i have sql scripts, i need to write in qlikview script in where condition, can anyone pleaase help.

( MOMREGION= 'HTSE' AND DOMAIN_CLASS= 'ZSERIES' AND ( UDT_EVENTTYPE LIKE 'EQQ%' OR UDT_EVENTTYPE IN ('OPSU070I', 'OPSU071I') ) OR MOMREGION= 'HTSE' AND DOMAIN_CLASS= 'ZSERIES' AND UDT_EVENTTYPE IN ('IEF450I', 'IEF451I', 'IEF452I', 'IEF453I' ) AND SUBSET_CLASS= 'BATCH' )

( MOMREGION= 'HTSN' AND DOMAIN_CLASS = 'ZSERIES' AND UDT_EVENTTYPE LIKE 'EQQ%' OR MOMREGION <> 'HTSL' AND DOMAIN_CLASS = 'ZSERIES' AND SUBSET_CLASS= 'CA7' )

( MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SERVICES IN ('HUBEU2', 'HUB FRANCE -HBFR', 'HUBDOH', 'HUBHMT', 'HBME-MULTI-COUNTRY-HUB-GROUP-ONE -OMM', 'HBME-MULTI-COUNTRY-HUB-GROUP-ONE -KWT', 'HBME-MULTI-COUNTRY-HUB-GROUP-ONE', 'HUBPAR', 'HUBHAR', 'HUBHGR', 'HUBHKE', 'HBME-MULTI-COUNTRY-HUB-GROUP-ONE -MNM', 'HUBHIL-DEV', 'HUBUAE', 'HUBHRU', 'HSSHUB', 'HUBHHQ', 'HUBHGB', 'HUBHES', 'HUBHIL', 'HBME-MULTI-COUNTRY-HUB-GROUP-TWO', 'HBME-MULTI-COUNTRY-HUB-GROUP-TWO -BAO', 'HBME-MULTI-COUNTRY-HUB-GROUP-THREE', 'HUBHDE', 'HUBHIT', 'HUBLOH', 'HUBHPL', 'HUBHZA', 'HUBE2B -HNL', 'HUBE2B -HLX', 'HUBHEI', 'HUBHCZ', 'HUBHSW', 'HUBE2B -HBE', 'HUBHD8') AND ( SUBSET LIKE '%BCH' OR SUBSET LIKE '%OWNER' OR SUBSET LIKE '%BCHTTS' ) AND DOMAIN_CLASS = 'ISERIES' AND NOT ORIGIN_OBJECT IN ('SSKEPALV1','SSKEPALV2') OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND ( SUBSET LIKE 'HUB%' AND UDT_ORIGINTYPE = 'Automation Point' OR UDT_GSDTEMPLATE = 'HBUS-GP-HUB-USA' ) AND DOMAIN_CLASS = 'ISERIES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND
SUBSET_CLASS LIKE '%BATCH%' AND UDT_ORIGINTYPE = 'Automation Point' AND DOMAIN_CLASS = 'ISERIES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND DOMAIN_CLASS = 'ISERIES' AND UDT_DOMAIN IN ('wink003', 'wink006', 'brum000', 'brum001') AND OBJECT_CLASS = 'ROBOT' )

( ( MOMREGION = 'HTSE' AND NOT COUNTRY = 'CH' AND DOMAIN_CLASS = 'CONTROL-M' ) OR ( MOMREGION = 'HTSE' AND NOT COUNTRY = 'CH' AND DOMAIN_CLASS like 'CTLM%' ) )

( ( MOMREGION IN ('HTSA', 'HTSN') AND DOMAIN_CLASS = 'CONTROL-M' ) OR ( MOMREGION IN ('HTSA', 'HTSN') AND DOMAIN_CLASS LIKE 'CTLM%' ) )

OR
( MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SERVICES IN ('AOC HUB', 'AUH HUB', 'BKH HUB', 'BSB HUB', 'CBH HUB', 'DAKHUB', 'HASE CN HUB', 'HASE MO HUB', 'HASE SG HUB', 'HBBM HUB', 'HTSO HUB', 'IMO HUB', 'INM HUB', 'JPM HUB', 'MAR HUB', 'MMO HUB', 'MNL HUB','MYH HUB', 'NZM HUB', 'SEL HUB', 'SGH HUB', 'TWM HUB', 'VNM HUB', 'AMH TREATS', 'HASE-CN-TREATS', 'HASE-HK-TREATS', 'HASE-SG-TREATS', 'HBBMTREATS', 'LDN TREATS', 'MNL TREATS', 'NZM TREATS', 'TWM TREATS', 'VNM TREATS', 'TEU-TREATS', 'TIA-TREATS', 'TID-TREATS', 'TME-TREATS', 'HBUS TREATS', 'AMH GSOPS', 'HASE GSOPS', 'INSN LIFE/400', 'MYH SMF', 'HASE HCC SMF', 'AMH REMIND', 'MMO REMIND', 'AMH HCC', 'HASE HCC', 'HBBM HCC', 'AUH ATMP', 'NZM ATMP', 'AMHK IMS', 'ASP-ME-HIE', 'AMH HIE', 'TWM CACS') AND ( SUBSET LIKE '%BCH' OR SUBSET LIKE '%OWNER' OR SUBSET LIKE '%BCHTTS' ) AND DOMAIN_CLASS = 'ISERIES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SUBSET_CLASS = 'HKBCH' AND UDT_ORIGINTYPE = 'Automation Point' AND DOMAIN_CLASS = 'ISERIES' )

Re: script help

tresB — Tue, 12 Feb 2019 06:36:09 GMT

If you are trying to fetch the data directly from the DB, you can use the same SQL query in qlik, like:

SQL SELECT
....
FROM ... WHERE <your condition>;

Re: script help

anushree1 — Tue, 12 Feb 2019 06:36:29 GMT

For using IN functionality of SQL in Qlikview please use the below format:

Where MATCH(Field,'Val1','Val2','Val3')

the AND, OR works as is in qlikview along with where as it does with SQL

Re: script help

tresB — Tue, 12 Feb 2019 06:41:07 GMT

And in addition to what Anushree suggested, you have to change wild character '%' to '*'

Re: script help

qlikapple — Tue, 12 Feb 2019 09:30:15 GMT

what about LIke and NOT

Re: script help

tresB — Tue, 12 Feb 2019 10:48:57 GMT

These are supported in qlik as well

topic Re: script help in QlikView

script help

Re: script help

Re: script help

Re: script help

Re: script help

Re: script help