Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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).