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

not equal to condition in set analysis(urgent....)

hi

i have a situation in which i am using an expression and in the expression i have to sum a measure based on two dimensions.

like sul({$<prodid={'a'},size shouldnt be equal to xl...........what is the sign to be used for not equal to???

1 Reply
swuehl
MVP
MVP

Try using

sum({$<prodid={'a'},size -= {'x'}>} Measure)

i.e. using minus-equal.

Hope this helps,

Stefan

P.S:

IMHO, it helps to not think of an comparision operator (equal resp. not equal) when looking at '=' or '-=' set operator, but of set theory operators (set assignment / union, exclusion operators).