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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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