Help with simple expression: if then statement

[#1]

Somewhat new to qlikview and I need to create a simple expression, saying that if a certain criteria is met (in this case, CountryName = 'USA'), then I want to count the distinct number of shipments coming out of that country.

I tried the following but it's not working:

=IF(CountryName = 'USA'),COUNT(DISTINCT(SHIPMENTS))

I want to make sure that the count I get is only for shipments coming out of the USA, not all shipments from all countries.  What is the proper expression?

Thanks!

[sunny_talwar · Accepted solution]

May be try one of these:

=If(CountryName = 'USA', Count(DISTINCT SHIPMENTS))

or

=Count(DISTINCT {<CountryName = {'USA'}>} SHIPMENTS)

[#3]

The second option worked.  Thank you!

=Count(DISTINCT {<CountryName = {'USA'}>} SHIPMENTS)

[sunny_talwar]

Then the if alternative of the set analysis is this:

=Count(DISTINCT If(CountryName = 'USA', SHIPMENTS))