how to use where clause in count?

[#1]

Hi,

   I am trying to create a text box with an expression where it does a count on Winning_Team with a Where clause.  

For example, i want to do a count where the [Total_Team] = [Winning_Team] .How to do this?

[MK_QSL]

=COUNT({<[Winning_Team] = {"=[Winning_Team]=[Total_Team]"}>}[Winning_Team])

[swuehl]

You can use conditional aggregations on a record base like this:

=Count( If( [Total_Team] = [Winning_Team], [Winning_Team]))

You can also use set analysis, but here you need to carefully identify a field to select on when you want to make 'per field group base' comparisons. If Winning_Team shows multiple records, the comparison Winning_Team = Total_Team could show distinct responses, so won't qualify for an expression search.

Conditional Aggregations

edit: and please carefully select a proper place to post your questions, QlikBug is a place to discuss issues in the software that are confirmed or assumed defects, not how to use the software in general (there are other places like 'new to QlikView / QlikSense'

[#4]

Does it work for Not equal to operator?

[swuehl]

Like this?

=Count( If( [Total_Team] <> [Winning_Team], [Winning_Team]))