topic Re: Help with simple expression: if then statement in QlikView

Help with simple expression: if then statement

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Help with simple expression: if then statement

sunny_talwar — Tue, 24 May 2016 17:48:14 GMT

May be try one of these:

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

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

Re: Help with simple expression: if then statement

Tue, 24 May 2016 21:04:49 GMT

The second option worked. Thank you!

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

Re: Help with simple expression: if then statement

sunny_talwar — Tue, 24 May 2016 23:38:18 GMT

Then the if alternative of the set analysis is this:

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