Count where asset quantity is less than 2

[#1]

It has been a while since i used QlikView and I am a bit rusty.

I have the following data.

UserID

ComputerName

I want to get a count of the users who have less than 2 unique computer names assigned to them.

[vishsaggi]

May be this? Not sure, can you share some sample data to look into.

= Count(TOTAL <UserID> DISTINCT CompName)

Or

= Count(TOTAL <CompName> DISTINCT UserID)

[sergio0592 · Accepted solution]

It works for me with:

=count({$<User_Id={"=count( TOTAL <User_Id> [Computer name])<2"}>} DISTINCT User_Id)

5 in my example

[#4]

Thank you!