Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
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