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: 
qlikapple
Creator
Creator

need help in sql query to convert in load script

Hi all , i have a query of

 

OPOWNER LIKE '%NCCDESK%' AND NOT OPOWNER LIKE '%NCCDESK3' AND NOTOPOWNER = 'NCCDESK99' AND NOT OWNER = 'CiscoMSO' ) AND SEV > 1

can anyone please convert in qlik script, i need to  keep in where condition in my qvd

 

Labels (1)
2 Replies
Gysbert_Wassenaar

Something like this:

WHERE

WildMatch(OPOWNER ,'*NCCDESK*')

AND NOT WildMatch(OPOWNER ,'*NCCDESK3')

AND NOT OPOWNER = 'NCCDESK99'

AND NOT OWNER = 'CiscoMSO' 

AND SEV > 1


talk is cheap, supply exceeds demand
qlikapple
Creator
Creator
Author

HI , I NEED THIS SQL QUERY ALSO TO GET WRIITEN IN QLIK SCRIPT ( MOMREGION = 'HSE' AND DOMAINCLASS = 'ZSER' AND ( TTYPE LIKE 'EQ%' OR TTYPE IN ('070I', 'U071I') ) OR MOMREGION = 'HTSE' AND DOMAINCLASS = 'ZSER' AND TTYPE IN ('F450I', 'IE51I', 'IEF4I', 'IEF4' ) AND SETCLASS = 'BATCH' ) OR ( MOMREGION = 'HSN' AND DOMAINCLASS = 'ZSER' AND TTYPE LIKE 'EQ%' OR MOMREGION <> 'HSL' AND DOMAINCLASS = 'ZSER' AND sETCLASS = 'CA7' ) OR ( MOMREGION IN ('HSA', 'HSE', 'HSN') AND SERVICES IN ('HUBHIL', 'HUBE', GROUP-TWO', 'HBME-MULTI-COUNTRY-HUB-GROUP-THREE', 'HUBHDE', 'HUBHIT', 'HUBLOH', 'HUBHPL') AND (SUBSET LIKE '%BCH' OR SUBSET LIKE '%OWNER' OR SUBSET LIKE '%BCHTTS' ) AND DOMAINCLASS = 'ISIES' AND NOT OBJECT IN ('SSKEPALV1','SSKEPALV2') OR MOMREGION IN ('HSA', 'HSE', 'HTSN') AND ( UBSET LIKE 'HUB%' AND tYPE = 'Automation Point' OR TEMPLATE = 'USA' ) AND DOMAINCLASS = 'ISES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SUBSETCLASS LIKE '%BATCH%' AND ORIGINTYPE = 'Automation Point' AND DOMAINCLASS = 'ISES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND DOMAINCLASS = 'ISERIES' AND DOMAIN IN ('wink003', 'wink006', 'brum000', 'brum001') ANDOBJECTCLASS = 'ROBOT' ) OR ( ( MOMREGION = 'HTSE' AND NOT REGION = 'CH' AND DOMAINCLASS = 'CONTROL' ) OR (MOMREGION = 'HTSE' AND NOT REGION = 'CH' AND DOMAINCLASS like 'CTLM%' ) ) OR ( (MOMREGION IN ('HSA', 'HSN') AND DOMAINCLASS = 'CONTROL' ) OR (MOMREGION IN ('HTSA', 'HTSN') AND DOMAINCLASS LIKE 'CTLM%' ) ) OR ( MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SERVICES IN ('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 DOMAINCLASS = 'ISEIES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SUBSETCLASS = 'HKBCH' AND ORIGINTYPE = 'Automation Point' AND DOMAINCLASS = 'ISERIES' )