Qlikview Alerts

[bobbydave]

I have an alert. Semi-working.

I get the email

My Condition is:

=  if([Control Description]= 'Claim Payment',
sum({< [Fiscal Year Month] = { '2015-02' },
[Country Code]={AU, BE, CO, DK, EE, FI, FR, DE, GR, IE, IT,KR, LT, LV, MX,
NL, NI, NO, PL, PT, ES, SE, CH, TK, UK} >}
//if Case Measures = 167, email which country has 167
  [Record Count]=1), null()) 

and stored in BM01

My message should say: Lithuania: Claim Payment is reported as 1

=if(
if([Control Description]= 'Claim Payment',
sum({<[Fiscal Year Month] = { '2015-02' } ,
[Country Code]={AU, BE, CO, DK, EE, FI, FR, DE, GR, IE, IT, KR, LT, LV, MX,
NL, NI, NO, PL, PT, ES, SE, CH, TK, UK} >}
//if Case Measures = 1, email which country has 1 
[Record Count]=1)),
Country & ': Claim Payment is reported as ' & sum([Record Count]), null())

I don't get the Country to come through through. I get the email saying : Claim Payment is reported as 1

Anyone any idea why my country doesn't appear?

[#2 · Accepted solution]

I am suspecting you may get more than one country value or one value with duplicates. To debug the issue, please create list boxes for fields using in the expression. Select the LB values using in the set analysis and you may see how many possible values are available for Country field. If you have only one value then use Only function or concat function.

=if(
if([Control Description]= 'Claim Payment',
sum({<[Fiscal Year Month] = { '2015-02' } ,
[Country Code]={AU, BE, CO, DK, EE, FI, FR, DE, GR, IE, IT, KR, LT, LV, MX,
NL, NI, NO, PL, PT, ES, SE, CH, TK, UK} >}
//if Case Measures = 1, email which country has 1 
[Record Count]=1)),
Only(Country) & ': Claim Payment is reported as ' & sum([Record Count]), null())

or

=if(
if([Control Description]= 'Claim Payment',
sum({<[Fiscal Year Month] = { '2015-02' } ,
[Country Code]={AU, BE, CO, DK, EE, FI, FR, DE, GR, IE, IT, KR, LT, LV, MX,
NL, NI, NO, PL, PT, ES, SE, CH, TK, UK} >}
//if Case Measures = 1, email which country has 1 
[Record Count]=1)),
Concat(Distinct Country,',') & ': Claim Payment is reported as ' & sum([Record Count]), null())