Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Set Analysis and Greater than Modifier

Hi

Need some help. I have a bunch of Services and Servers


The Services are unique, but the servers are shared. So I am counting how many Services are on each Server.

(Count([IT Service Name])


However from these results I only want to see servers that have more than 3 services? How do I add the greater than > modifier to show these results?

Server.PNG

1 Reply
MVP
MVP

Re: Set Analysis and Greater than Modifier

May be this:

Count({<[Server Name] = {"=Count([IT Service Name]) >= 3"}>}[IT Service Name])