Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unique id instances across multiple fields

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

0 Replies