Qlik Community

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
william_fu
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.

1 Solution

Accepted Solutions
Highlighted

Re: Distinct from two set analysis

May be this

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

View solution in original post

2 Replies
Highlighted

Re: Distinct from two set analysis

May be this

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

View solution in original post

Highlighted
william_fu
Contributor II

Re: Distinct from two set analysis

Perfect, thanks!