Sum if and Distinct

[Qlikuser09]

if([Allowed]='A',Count(distinct [UserID]),0) ----- not working for counting distinct user ID based on selection

[tresesco · Accepted solution]

Instead of If(Count... structure, try Count(If(.. structure, like:

Count(Distinct if([Allowed]='A', [UserID]))

[Taoufiq_Zarra · Accepted solution]

Count({<Allowed={'A'}>}distinct [UserID])