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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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