topic Re: Qlikview Equation in QlikView

Qlikview Equation

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview Equation

t_chetirbok — Fri, 25 Mar 2016 13:49:07 GMT

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

Re: Qlikview Equation

sunny_talwar — Fri, 25 Mar 2016 13:52:48 GMT

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

Re: Qlikview Equation

bobbydave — Wed, 30 Mar 2016 11:00:07 GMT

This works a charm.

Thank you.