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???

2 Replies
Not applicable
Author

Try this Sum({$<prodid={'*'}-{'a'}>} )

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

SImpler than that

Sum({<prodid-={'a'}>} size)

The expression will work. Don't worry about the wiggly line syntax warning, but that's a well known bug in the script editor syntax check.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein