topic Set Analysis (How exclude one condition) in QlikView

Set Analysis (How exclude one condition)

Fri, 10 Jul 2009 01:55:50 GMT

Hello to all

I have an expression with Set analysis, to count the customers that have the condition-1, but do I want not to include the customer that have the condition-2 ¿How can make it?.

Example

Count

( {$<d_year={*}, d_month={*}, d_day={*}, Condition-1={'PREMIUM'},Date_num = {$(vPeriodo)} >} CustomerID)

¿ Where i add the condition-2 ?

Thanks

Set Analysis (How exclude one condition)

Fri, 10 Jul 2009 02:09:24 GMT

If you're looking to exclude any record that has a Condition-2, then make it equal an empty set.

Condition-2 = {}

That means only count when Condition-2 is null.

Set Analysis (How exclude one condition)

Fri, 10 Jul 2009 02:16:52 GMT

Thanks,

But I need to count the customes that are condicion-1=PREMUIN and that Consicion-2 <> '1' (not equal to ' 1 ')

Set Analysis (How exclude one condition)

Fri, 10 Jul 2009 02:44:39 GMT

Condition-2 -= {'1'}

The -= is the Exclusion and should count only when Condition-2 does not equal 1.

Set Analysis (How exclude one condition)

Fri, 10 Jul 2009 02:59:11 GMT

Thanks, for their help, it works well