Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
marqupcmb
New 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

Re: count with condition "distinct"

May be this (Note a negative sign before 😃

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

4 Replies

Re: count with condition "distinct"

May be this (Note a negative sign before 😃

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

Re: count with condition "distinct"

Or

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

MVP
MVP

Re: count with condition "distinct"

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
New Contributor II

Re: count with condition "distinct"

Thanks!! It works