Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
woody1982
Contributor III
Contributor III
‎2020-03-03 03:00 AM

Error with empty fields

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.

 

Labels (1)
Labels
784 Views
0 Likes
3 Replies
tresB
Champion III
Champion III
‎2020-03-03 03:12 AM

Try this?

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

773 Views
0 Likes
woody1982
Contributor III
Contributor III
‎2020-03-03 03:33 AM
Author

In response to tresB

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

763 Views
0 Likes
tresB
Champion III
Champion III
‎2020-03-03 04:13 AM

In response to woody1982

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

738 Views