Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
jkonicki
New Contributor

Count with Or

Hello,

I am trying to use a Count statement with conditions, but I want those conditions to be Or instead of And's. Below is an example I have that doesn't seem to be doing anything:

count({$<STATUS_TITLE = 'Pending Certification' or STATUS_TITLE = 'Pending Completion'or STATUS_TITLE = 'Pending Qualification'>} RTC_TITLE)

It will count RTC_TITLE if one of those conditions is correct.

Any help or guidance is appreciated.

Thanks!

1 Solution

Accepted Solutions

Re: Count with Or

Try this:

=Count({$<STATUS_TITLE = {'Pending Certification', 'Pending Completion', 'Pending Qualification'}>} RTC_TITLE)

5 Replies

Re: Count with Or

Try this:

=Count({$<STATUS_TITLE = {'Pending Certification', 'Pending Completion', 'Pending Qualification'}>} RTC_TITLE)

buzzy996
Honored Contributor II

Re: Count with Or

try tis way,

=If(STATUS_TITLE = 'Pending Certification',Count( RTC_TITLE),

If(STATUS_TITLE = 'Pending Completion',Count( RTC_TITLE),

Count( RTC_TITLE)))


jkonicki
New Contributor

Re: Count with Or

Sunny,

This worked exactly the way I was looking for. Thank you so much! I appreciate the help!

-Jordan

jkonicki
New Contributor

Re: Count with Or

Shiva,

Thank you for the suggestion, but in this way I have to have certain selections chosen to have my statistics show up the way I want them to.

-Jordan

Re: Count with Or

Not a problem Jordan

I am glad I was helpful.

Community Browser