Qlikview Alerts

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

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?

Re: Qlikview Alerts

Fri, 15 Jan 2016 15:13:52 GMT

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())

=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())

topic Re: Qlikview Alerts in QlikView

Qlikview Alerts

Re: Qlikview Alerts