Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

sum({<Extracontabile = {' '}>} [ImportoSaldo])

Hi,

Sum if the value of the non-accounting field is null


sum({<Extracontabile = {' '}>} [ImportoSaldo]) but not workint

9 Replies
Highlighted

May be this:

Sum({<Extracontabile -= {'*'}>} [ImportoSaldo])

Highlighted
Champion III
Champion III

try below

sum({<Extracontabile -= {" *"}>} [ImportoSaldo])

Highlighted
Partner
Partner

Hi,

the formula has extract the values ​​<> null.


Now I need to calculate, the values = null. Could you help me?

1Copia.png

Highlighted
Contributor III
Contributor III

Fabio,

you can find a  useful document at https://community.qlik.com/docs/DOC-4951

Regards

Highlighted
Champion III
Champion III

try below

sum({$<Extracontabile ={"=len(trim(Extracontabile ))=0"}>} [ImportoSaldo])

Highlighted
Partner
Partner

Hi,

unfortunately it does not work

Copia.png

Highlighted

Is there a field which uniquely defines Extracontabile in your database?

Highlighted
Partner
Partner

Copia.pngthanks anyway, revenue for the value difference

Highlighted
Partner
Partner

Hi,

thanks anyway

1Copia.png