Qlikview Equation

[bobbydave]

I have an equation that I am trying to figure out.

The below equation should equate to 1 (TRUE).

At the moment I am getting 0.

Any ideas?

Sum(
If(
Aggr(
Sum({<[Control Description] = {'Policy New Business'},
[Fiscal Year Month] = {"$(=Date(vMonthlyEnd, 'YYYY-MM'))"}>}
//{"$(=Date(AddMonths(Max(vMonthlyEnd), -1), 'YYYY-MM'))"}>}
[Record Count]),
Country) = 0,
1, 0))

where vMonthlyEnd is :

Let vMonthlyEnd = num(MonthStart(AddMonths(Today(), -1))); // Last Month

[t_chetirbok · Accepted solution]

Hi!

try to use

Sum(
If(
Aggr(
Sum({<[Control Description] = {'Policy New Business'},
[Fiscal Year Month] = {"$(=Date($(vMonthlyEnd), 'YYYY-MM'))"}>}
[Record Count]),
Country) = 0,
1, 0))

[sunny_talwar]

If what Tatsiana‌ provided did not work, would you be able to share a sample?

[bobbydave]

This works a charm.

Thank you.