Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

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

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

MVP
MVP

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

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