Count a number of distinct Session Ids in a Column but exclude certain users

[ColossustheFish]

Hi there. I'm a new user of Qlik Sense and I'm creating a chart and I want to do a distinct count of sessions in one column but I want to exclude certain user IDs from the count. So far I have the following formula.

Count({<Agent_ID-={'UserID1@company.com','UserID27@company.com','UserID33@company.com'}>} Distinct Session_ID)

Unfortunately this seems to return the same number of values as

Count(Distinct Session_ID)

Where am I going wrong please?

[menta]

try = -

Count({<Agent_ID = - {'UserID1@company.com','UserID27@company.com','UserID33@company.com'}>} Distinct Session_ID)

[ColossustheFish]

Unfortunately that just makes the count negative instead of positive (bottom line on chart). 

[BrunPierre]

Hi, The syntax seems correct, try with double quotes.

{"UserID1@company.com", ...}

[ColossustheFish]

Same result...

= - Count({<Agent_ID = - {"UserID1@company.com","UserID27@company.com",'"UserID33@company.com"}>} Distinct Session_ID)

[menta]

the expression is 

= Count({<Agent_ID = - {'UserID1@company.com','UserID27@company.com','UserID33@company.com'}>} Distinct Session_ID)

what is the dimension for the x axes?

[ColossustheFish]

But that just takes me back to returning the same value...

[ColossustheFish]

I still haven't managed to sort this. Does anybody else have any suggestions?