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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I make a set analysis statement with a not equal to <> field

I want to exclude information from my totals in a chart. I want to set up a set analysis, stating if the field is not equal to ___ than sum the total cost. It does not like the not equal to symbols...

sum({<Agent#<>{"55555555,54444444,53333333,52222222,51111111"}>} Total)

Thank you,

Venus

4 Replies
johnw
Champion III
Champion III

Perhaps this?

sum({<Agent#-={55555555,54444444,53333333,52222222,51111111}>} Total)

Not applicable
Author

Sum ( {$< Agent# -= {'55555555,54444444,53333333,52222222,51111111''}>} Total )

(would be the correct syntax I believe.. therefore the 'not equal to' would be '-=')

NOTE: QlikView 10 actually reports this as a bad syntax portion (underlines in red) yet will report "Expression OK" and work properly.

Best,

Jared

Not applicable
Author

Thank you, John! It worked.

Not applicable
Author

Thank you, Jared. I appreciate the fast response time.

Venus