QlikSense shows Zero as -

[Samanehsorournejad]

Hi everyone,
I'm in the Process Migration from QlikView to QlikSense, I have the App with this Measure :
if(Count({$ <Ereignisart=
//,KuhVisionEnde={"nein"}
>}KV_GESUNDDIAGNOSE.ID)=0,'xxx',Date(max({$ <Ereignisart={'GESUNDDIAGNOSE'},KuhVisionEnde={"nein"}>}%Datum),'DD.MM.YYYY'))
it shows me 0 in QlikView but in the same Column in Qlik Sense it shows me '-'.

is there anyone who could help me to know why QlikSense shows me - instead of zero?

Thanks in Advanced

QlikViewQlikSense

[neerajthakur]

It does not convert null to zero itself. You can use coalesce function for it in editor.

[Samanehsorournejad]

it is not null, but missing Value.

Hi every one,

is there any person who knows how to replace missing Value in QlikSense with the spacial Character or symbol

[neerajthakur]

Define missing value.

Use if(len(expression)<0,0)

[Aditya_Chitale]

@Samanehsorournejad 

try this: 

=if(isnull(measure),'0',measure)

Regards,

Aditya

[neerajthakur]

He's saying it's not null values.

[Clever_Anjos]

try the coalesce() function to replace nulls with 0´s