Unique id instances across multiple fields

Thu, 02 Jul 2015 14:29:41 GMT

currently I am using the following set analysis to count the number of unique occurrences of a party_id in a date range. I'm needing to count the number of unique id's that occur across a combination

=If( vFundTypeReal = '1' AND vFundTypeReleased = '1' AND vFundTypePlayable ='1',
(COUNT (
{$
<SUMMARY_DATE = {">=$(vStartDate)<=$(vEndDate)"}, PARTY_ID={"=sum(PNL_REAL+PNL_RELEASED_BONUS+PNL_PLAYABLE_BONUS)<>0"} >
}
[PARTY_ID])
)
)

This works (mostly), however there are instances where the sum is zero'd out because there are positive and negative values that cancel each other out. Does anyone have any suggestions using set analysis to count distinct ID's in a date range, where occurrences in any of the three fields -= 0?

Thanks in advance

topic Unique id instances across multiple fields in QlikView

Unique id instances across multiple fields