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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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