Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
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

Community Browser