Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not equal to in set analysis

I'm interested in creating an expression in qlikview that will calculate the sum of [Current Balance] for all rows where Field1 is not equal to 'H'. For some reason qlikview is not liking any of the not equal operators such as <> or !=. Is there a way around this? Thanks.

3 Replies
Not applicable
Author

Try: sum({<Field 1 -= {'H'}>}[Current Balance])

Set analysis is like making a selection. The '-=' selects all of Field1 except 'H'

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Jacob's solution is the most straightforward one.

As a side note, the = in a set modifier should be looked at as an assignment operator ("should be filled with values from the following set") and not as a relational operator ("is equal to?")

On the other hand, if you try to use a 'not equal to' operator inside the explicit set specification (the part between {"..."}), you can use advanced search, like in:

=sum({<Field1 = {"=Field1 <> 'H'"}>} [Current Balance])

After the equal sign inside the explicit set specification, any regular QlikView expression can be used. See Advanced Search in QlikView Help.

Joseph_Musekura
Support
Support

Hi,

You can use this as reference as well

http://community.qlik.com/message/12808#12808

Regards,