topic Re: Is there a way to use the OR function in script in QlikView

Is there a way to use the OR function in script

Tue, 19 Aug 2014 09:48:13 GMT

Hi,

I am trying to use an OR function in Qlkiview while loading the script

IF(OR(Accept_compliance = 'No',

Accept_compliance ='Expired',

Convert_compliance ='Expired',

Convert_compliance ='No',

Closed_compliance ='No',

Closed_compliance ='Expired'),'No','Yes')

as Total_Compliance

Is there a way I can achieve the same or can anyone help me with a possible workaround in the script to load the data.

Note: All the compliance are created as dimensions using the If condition in the script.

Any help on the issue will really be helpful as I am really stuck.

Regards,

Prathamesh Sable

Re: Is there a way to use the OR function in script

tresB — Tue, 19 Aug 2014 09:51:24 GMT

Try like:

If( Accept_compliance = 'No' Or Accept_compliance ='Expired' Or ........

Re: Is there a way to use the OR function in script

northerner — Tue, 19 Aug 2014 09:56:48 GMT

This should work:

if
(
     Accept_compliance = 'No'
     or Accept_compliance ='Expired'
     or Convert_compliance ='Expired'
     or Convert_compliance ='No'
     or Closed_compliance ='No'
     or Closed_compliance ='Expired',
     'No',
     'Yes'
)as Total_Compliance

In Qlikview OR is an operator, not a function

Re: Is there a way to use the OR function in script

sujeetsingh — Tue, 19 Aug 2014 09:59:37 GMT

Of course you can use OR and AND both

Re: Is there a way to use the OR function in script

jagan — Tue, 19 Aug 2014 10:23:53 GMT

Hi,

Use OR like below in Qlikview

LOAD

IF(Accept_compliance = 'No' OR

Accept_compliance ='Expired' OR

Convert_compliance ='Expired' OR

Convert_compliance ='No' OR

Closed_compliance ='No' OR

Closed_compliance ='Expired','No','Yes')

as Total_Compliance

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: Is there a way to use the OR function in script

marcus_sommer — Tue, 19 Aug 2014 10:30:10 GMT

Try this:

if(match(Accept_compliance, 'No', 'Expired') or match(Convert_compliance, 'No', 'Expired') or match(Closed_compliance, 'No', 'Expired'),'No','Yes')

- Marcus