Not equal in Where clause in expression

[Anonymous]

Hello.

What would be the correct syntax in Qlik Sense, if I want to summarize "CURRENT_AMOUNT" where field "SIDE" is not null ?

My guess was:

=Sum({<IsNull(SIDE)=0>} CURRENT_AMOUNT)

but it gives me error.

Thank you.

[sunny_talwar · Accepted solution]

May be try this

=Sum({<SIDE = {"*"}>} CURRENT_AMOUNT)

[Anonymous]

Hello Sunny,

Thank you, I haven't viewed this problem from perspective of "any text in field"

That worked for me

[arvind1494]

=Sum({<SIDE = {"your requirement"}>} CURRENT_AMOUNT)