Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
william_fu
Creator II
Creator II

Distinct from two set analysis

Is there a way to get a distinct count between two set analysis measures?

In the example below, I want the sum of the measures, where Measure 1 = 1306 and Measure 2 = 162, but there are 6 records that fit the criteria in both sets.

Measure 1: Count({$<CodStatus={'20', '21', '22'}>} Distinct NroProposta)

Measure 2: Count({$<CodStatus={'23', '71'}, DscStatus={'AA', 'AD'}>} Distinct NroProposta)

Ideally I want a Measure 3 that doesn't count those 6 records twice, returning 1462 instead of 1468.

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count({$<CodStatus={'20', '21', '22'}>+<CodStatus={'23', '71'}, DscStatus={'AA', 'AD'}>} Distinct NroProposta)

View solution in original post

2 Replies
sunny_talwar

May be this

Count({$<CodStatus={'20', '21', '22'}>+<CodStatus={'23', '71'}, DscStatus={'AA', 'AD'}>} Distinct NroProposta)

william_fu
Creator II
Creator II
Author

Perfect, thanks!