Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It does not convert null to zero itself. You can use coalesce function for it in editor.
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
Define missing value.
Use if(len(expression)<0,0)
He's saying it's not null values.
try the coalesce() function to replace nulls with 0´s