Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sahajaqlik
Not applicable

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

 

2 Replies
Highlighted
Gysbert_Wassenaar
Not applicable

Re: need help in sql query to convert in load script

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
sahajaqlik
Not applicable

Re: need help in sql query to convert in load script

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