Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this
=Sum({<SIDE = {"*"}>} CURRENT_AMOUNT)
Hello Sunny,
Thank you, I haven't viewed this problem from perspective of "any text in field"
That worked for me
=Sum({<SIDE = {"your requirement"}>} CURRENT_AMOUNT)