Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bmchale1983
Contributor III
Contributor III

count distinct 2 fields

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?

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

May be this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bmchale1983
Contributor III
Contributor III
Author

TY!