topic Re: Not equal to in set analysis in QlikView

Not equal to in set analysis

Thu, 05 Jun 2014 16:52:52 GMT

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.

Re: Not equal to in set analysis

Thu, 05 Jun 2014 16:55:13 GMT

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

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

Re: Not equal to in set analysis

Peter_Cammaert — Thu, 05 Jun 2014 19:57:53 GMT

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.

Re: Not equal to in set analysis

Joseph_Musekura — Thu, 05 Jun 2014 20:20:54 GMT

Hi,

You can use this as reference as well

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

Regards,