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: 
marqupcmb
Contributor II
Contributor II

count with condition "distinct"

Dears I'm trying to count a text value if it is distinct to a specific value but it doesn't count

Im trying with this expression

=Count({<Status={'MTY'}, PoD={'<>PEPAI'}>} Container)

also tried with

If(Status='MTY'

     AND PoD<>'PEPAI',

    Count(Container)

  )

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be this (Note a negative sign before 😃

=Count({<Status={'MTY'}, PoD -= {'PEPAI'}>} Container)

View solution in original post

4 Replies
sunny_talwar

May be this (Note a negative sign before 😃

=Count({<Status={'MTY'}, PoD -= {'PEPAI'}>} Container)

sunny_talwar

Or

=Count({<Status={'MTY'}, PoD = e({<PoD = {'PEPAI'}>})>} Container)

swuehl
MVP
MVP

Or modifying your second expression (using a record based evaluation, which could perform worse than set analysis):

=Count( If( Status = 'MTY' and PoD <> 'PEPAI', Container))

marqupcmb
Contributor II
Contributor II
Author

Thanks!! It works