Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted

Try this:

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

View solution in original post

5 Replies
Highlighted

Try this:

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

View solution in original post

Highlighted
Master II
Master II

try tis way,

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

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

Count( RTC_TITLE)))


Highlighted
Contributor II
Contributor II

Sunny,

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

-Jordan

Highlighted
Contributor II
Contributor II

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

Highlighted

Not a problem Jordan

I am glad I was helpful.