topic Re: Count where asset quantity is less than 2 in QlikView

Count where asset quantity is less than 2

Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 13 Apr 2017 21:34:59 GMT

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

= Count(TOTAL <UserID> DISTINCT CompName)

= Count(TOTAL <CompName> DISTINCT UserID)

sergio0592 — Thu, 13 Apr 2017 22:06:19 GMT

It works for me with:

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

5 in my example

Sat, 15 Apr 2017 23:10:59 GMT

Thank you!