Error with empty fields

[woody1982]

Hello,
I load the table "IDNLF" and "EBELN", but with some empty fields the "EBELN" appears twice and "IDNLF" is filled with a "-".
Since I only want to count the filled "IDNLF", the value is of course not correct, since the "-" are also counted.
The problem is also that Qlikview doesn't seem to see this as a "-" and I can't rule it out.

(count (DISTINCT if(IDNLF<>'',EBELN))

does anyone know the problem and have a solution?

Thanks a lot.

[tresesco]

Try this?

count (DISTINCT {<IDNLF={"*"}>} EBELN)

[woody1982]

unfortunately no change.
He doesn't recognize it as an empty space or a "-"

[tresesco]

Could you share your sample app explaining the expected output in that context?