Sum (A) when B equal 1,2 and distinct C

[richard24best]

Hi team,

I am new to Qlikview and have a request on my Dashboard to publish the data as per below :

Columns I have are - ID, Matched and Entries

From the above I need Sum of Entries when Matched is 1 and 2, Distinct ID

Did try this expression excluding Distinct it works fine but I am not able to guess where to include DISTINCT ID

SUM({<[Matched]={'1'}> + <[Matched]={'2'}>}[Entries])

Appreciate your time and support

[PrashantSangle]

try below

Sum({<Matched={1,2}>}Entries)

Regards,
Prashant Sangle

[sunny_talwar · Accepted solution]

May be this...

Sum(Aggr(
  Sum(DISTINCT {<[Matched] = {'1', '2'}>} [Entries])
, ID))

[richard24best]

Thanks Sunny for your prompt support, it worked.