How to display a value that does not exist

[Balthazar]

Hello I currently have empty values in my table and I would like to replace them with a "0".
I have already tried these solutions:

- if(isnull(FIELDNAME,0,FIELDNAME),
- if (FIELDNAME) = '-',0,FIELDNAME)
- if (len(trim(FIELDNAME) =0, 0, FIELDNAME))
-if (not Exist(FIELDNAME), 0 , FIELDNAME)

I need help please.

[khaoulaaa]

Hello @Balthazar ,

Try to add your field as measure and not as dimension and use this expression:

if(isnull(FIELDNAME),0,FIELDNAME) 

[ift_isabelle]

coalesce(FIELDNAME, '0')

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...