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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Quick Help SetAnalysis (using <> operator)

=count({$<[FIELD1]={"Sales"}>} [FIELD2])

I would like to count, using set analysis, excluding FIELD1="Sales"

would be something like this:

=count({$<[FIELD1]<>{"Sales"}>} [FIELD2])

It seems that using "< >" operators in setanalysis is not property...

Tks!

1 Solution

Accepted Solutions
Not applicable
Author

hi try this:

=count({$<[FIELD1]-={"Sales"}>} [FIELD2])

regards

View solution in original post

3 Replies
Not applicable
Author

hi try this:

=count({$<[FIELD1]-={"Sales"}>} [FIELD2])

regards

Not applicable
Author

count({ $<FieldName= (FieldName - {"CustomerId"} ) >} FieldName)

Not applicable
Author

It perfectly answered my question!

Tks