Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Partner
Partner

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

what about like and NOT