topic Re: count distinct 2 fields in QlikView

count distinct 2 fields

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

Hello,

I have been able to come up with the following equation which gives me total distinct count of days, but I need it to have BDI Flag = 1.

=Sum(Aggr(Count(Distinct ACCT_OPEN_DT),BDI_Flag))

when I do this, it still gives me same count.

=Sum(Aggr(Count(Distinct ACCT_OPEN_DT),BDI_Flag='1'))

Any ideas?

Anil_Babu_Samineni — Mon, 03 Jul 2017 17:23:50 GMT

May be this

=Sum(Aggr(Count({<BDI_Flag = {1}>} Distinct ACCT_OPEN_DT),BDI_Flag))

bmchale1983 — Mon, 03 Jul 2017 17:25:42 GMT

TY!