Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aantonyan
New Contributor

Not equal in Where clause in expression

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Not equal in Where clause in expression

May be try this

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

3 Replies
MVP
MVP

Re: Not equal in Where clause in expression

May be try this

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

aantonyan
New Contributor

Re: Not equal in Where clause in expression

Hello Sunny,

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

That worked for me

arvind1494
Contributor III

Re: Not equal in Where clause in expression

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