Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted

May be try this

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

View solution in original post

3 Replies
Highlighted

May be try this

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

View solution in original post

Highlighted
Contributor II
Contributor II

Hello Sunny,

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

That worked for me

Highlighted
Specialist
Specialist

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