# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save \$200. Learn More
Contributor 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.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Distinct from two set analysis

May be this

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

2 Replies
Highlighted
MVP

## Re: Distinct from two set analysis

May be this

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

Highlighted
Contributor II

Perfect, thanks!