topic Re: Error with empty fields in QlikView

Error with empty fields

woody1982 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Error with empty fields

tresB — Tue, 03 Mar 2020 08:12:46 GMT

Try this?

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

Re: Error with empty fields

woody1982 — Tue, 03 Mar 2020 08:33:01 GMT

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

Re: Error with empty fields

tresB — Tue, 03 Mar 2020 09:13:13 GMT

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