Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sahajaqlik
Not applicable

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

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

 

Highlighted
sahajaqlik
Not applicable

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

what about like and NOT