Set Analysis and Condition

[#1]

Hi All

I have an expression which is counting for only where Application Name has more than 5 users

Count({<  [Application Name] = {"=count({<[Application Name]=>}DISTINCT [Authenticated user]) >5"}  >}DISTINCT [Authenticated user] )

I also would like to use and condition so [Application Name] <> 'lease license.qvw'

[#2 · Accepted solution]

Count({<  [Application Name] = {"=count({<[Application Name]=>}DISTINCT [Authenticated user]) >5"} - {"lease license.qvw"}  >}DISTINCT [Authenticated user] )

Thanks

AJ

[#3]

What does this - means " or " 

[Anonymous]

It is a set operator:

The two most common are Union "+" and Exclusion "-".

So in this case "-" exclude from the equation

[#5]

Faisal,

The - (minus) sign indicates that you remove the second set from the first one.

Ajay has created two sets: your 1st one and the second that is removed from the frst one.

+ = Union

- = Exclusion

* = Intersection

Fabrice

[#6]

Thanks All