topic Re: Set Analysis and Condition in QlikView

Set Analysis and Condition

Wed, 22 Jan 2014 22:20:53 GMT

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'

Re: Set Analysis and Condition

Wed, 22 Jan 2014 23:05:50 GMT

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

Thanks

Re: Set Analysis and Condition

Thu, 23 Jan 2014 14:40:57 GMT

What does this - means " or "

Re: Set Analysis and Condition

Anonymous — Thu, 23 Jan 2014 14:45:12 GMT

It is a set operator:

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

So in this case "-" exclude from the equation

Re: Set Analysis and Condition

Thu, 23 Jan 2014 14:45:45 GMT

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

Re: Set Analysis and Condition

Thu, 23 Jan 2014 15:04:11 GMT

Thanks All