Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sahajaqlik
Contributor

hi need one more query want to convert in qlik script

sql query want to convert in qlik script

 

(OPOWNER = 'GCCDESK4' OR OPOWNER = 'GCCDESK5' OR OPOWNER LIKE '%HASEDESK%' OR OPOWNER LIKE '%NCCDESK%' OR OPOWNER LIKE 'GCCDESK0%' OR OPOWNER LIKE 'HKRCCDESK0%' OR OPOWNER LIKE 'UKRCCDESK0%')
OR
(DOMAIN_CLASS  = 'NETWORK')
OR
(MCNAME = 'Autoalert' OR MCNAME = 'gmom_monitoring' OR MCNAME = 'gmom_stats' OR MCNAME = 'piBEM_GBM_FR' OR MCNAME = 'rsBES' OR MCNAME = 'System')
OR
(OWNER LIKE 'DASHBOARD%' OR OWNER LIKE 'HK_DASHBOARD%' OR OWNER LIKE 'NO_DISPLAY%' OR OWNER LIKE '%GENEOS%' OR OWNER LIKE 'HBTR_%' OR OWNER LIKE 'HTSE_TECH_TR%' OR OWNER LIKE 'HTSE_TR_%' OR OWNER LIKE 'OAT%')

OR
(MOMREGION = 'HTSL')

OR
(SEV_ID < 2)

OR
( MOMREGION = 'HTSE' AND DOMAIN_CLASS = 'ZSERIES' AND (OPOWNER LIKE 'UKRCCDESK3%' OR (NOT (OPOWNER LIKE '%DESK%'))) AND (OWNER LIKE '%CSS%' OR OWNER LIKE 'OR OWNER LIKE 'Net%' OR OWNER LIKE 'NET%' OR OWNER LIKE 'MEDIA%' OR OWNER = 'WIN') )

OR
( MOMREGION = 'HTSE' AND DOMAIN_CLASS = 'ZSERIES' AND SEV_ID = '2' AND (OPOWNER LIKE 'UKRCCDESK3%' OR (NOT ( OPOWNER LIKE '%DESK%'))) AND ( OWNER <> 'BATCH_PRI' AND OWNER <> 'BRD_AND_BATCH_PRI' AND ( NOT (OWNER LIKE 'HBFR_TECH_MF%')) AND (NOT (OWNER LIKE 'IBMOPS_BATCH%')) AND (NOT (OWNER LIKE 'IBMOPS_SERVICE%')) AND (NOT (OWNER LIKE 'ZSERIES_UKOPS_%'))) )

OR
( MOMREGION = 'HTSE' AND DOMAIN_CLASS = 'ISERIES' AND (OPOWNER LIKE 'UKRCCDESK3%' OR (NOT (OPOWNER LIKE '%DESK%'))) AND (OWNER = 'HBME_ATM_PRI' OR OWNER LIKE '%CSS%') )

OR
( MOMREGION = 'HTSE' AND DOMAIN_CLASS = 'ISERIES' AND SEV_ID = '2' AND (OPOWNER LIKE 'UKRCCDESK3%' OR (NOT (OPOWNER LIKE '%DESK%'))) AND (NOT (OWNER LIKE 'HBFR_TECH_AS4%')) AND (NOT (OWNER LIKE 'HBMT_TECH_AS4_PRI%')) AND (NOT (OWNER LIKE 'HTSE_TECH_I_OP%')) AND (NOT (OWNER LIKE 'ISERIES_UKOPS_%')) )

OR
( MOMREGION = 'HTSE' AND DOMAIN_CLASS <> 'ISERIES' AND DOMAIN_CLASS <> 'ZSERIES' AND (OPOWNER LIKE 'UKRCCDESK3%' OR (NOT (OPOWNER LIKE '%DESK%'))) AND (OWNER LIKE '%ALERTAPI%' OR OWNER LIKE '%CSS%' OR OWNER LIKE '%GCC%' OR OWNER LIKE '%TECH_AD%' OR OWNER LIKE 'GPSS%' OR OWNER LIKE 'net%' OR OWNER LIKE 'SABB%') )

OR
( MOMREGION = 'HTSE' AND DOMAIN_CLASS <> 'ISERIES' AND DOMAIN_CLASS <> 'ZSERIES' AND SEV_ID = '2' AND (OPOWNER LIKE 'UKRCCDESK3%' OR (NOT (OPOWNER LIKE '%DESK%'))) )

OR
( MOMREGION = 'HTSE' AND DOMAIN_CLASS <> 'ISERIES' AND DOMAIN_CLASS <> 'ZSERIES' AND OWNER  LIKE 'SABB%' )
OR
( MOMREGION = 'HTSN' AND INCIDENT_TEMPL = 'TICKET' AND NOT (OWNER LIKE '%_PRI') )
OR
( MOMREGION = 'HTSN' AND _SERVICES = 'NO-SERVICE' AND INCIDENT_ID_ORIG = 'FAILED (64)' )
OR
( MOMREGION = 'HTSN' AND UDT_ITMGMTPROCESS LIKE 'DASH_CEF_V%' AND PARAMETER_NAME LIKE 'DSB%' )

2 Replies
arvind_patil
Valued Contributor III

Re: hi need one more query want to convert in qlik script

Hi,

Write like below:

 

wildmatch(OPOWNER ,'GCCDESK4' , 'GCCDESK5' , '%HASEDESK%' , '%NCCDESK%', 'GCCDESK0%','HKRCCDESK0%','UKRCCDESK0%')
OR
wildmatch(DOMAIN_CLASS, 'NETWORK')

..rest all

Thanks & Regards,

Arvind Patil

 

sahajaqlik
Contributor

Re: hi need one more query want to convert in qlik script

what about like and NOT