Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
leocattqv
Creator
Creator

Using IF and OR

Hi All,

I have a list of Step status in records and I need to determine late and overdue.  this is what I have so far, but I get an error out.

Any suggestions?

=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or

( if([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'),1)

1 Solution

Accepted Solutions
MarcoWedel

=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or

[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime',1))

View solution in original post

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The red indicates unbalanced parens, And there appear to be no difference between the two ifs. I think this is what you want.

=COUNT(

IF(([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime')

,1)

)

-Rob

maxgro
MVP
MVP

for syntax maybe

=COUNT(IF(    ([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or

                      ([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime')

            ,1) )

Anonymous
Not applicable

=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or
([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'),1)

MarcoWedel

=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or

[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime',1))

leocattqv
Creator
Creator
Author


thanks all, I really appreciate it,  that did it.

MarcoWedel

Hi,

rwunderlich  is right,

[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or [STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'

is equal to

[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'

so his solution might be the better choice if this is, what you are looking for.

regards

Marco