Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis (How exclude one condition)

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





4 Replies
Not applicable
Author

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.

Not applicable
Author

Thanks,

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

Not applicable
Author

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

Not applicable
Author

Thanks, for their help, it works well