Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count where asset quantity is less than 2

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.

1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

It works for me with:

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

5 in my example

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

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
Specialist III
Specialist III

It works for me with:

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

5 in my example

View solution in original post

Not applicable
Author

Thank you!