Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

May be this:

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

Chanty4u
Esteemed Contributor III

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

try below

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

Partner
Partner

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

Hi,

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


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

1Copia.png

gferran
New Contributor III

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

Fabio,

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

Regards

Chanty4u
Esteemed Contributor III

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

try below

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

Partner
Partner

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

Hi,

unfortunately it does not work

Copia.png

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

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

Highlighted
Partner
Partner

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

Copia.pngthanks anyway, revenue for the value difference

Partner
Partner

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

Hi,

thanks anyway

1Copia.png