Discussion Board for collaboration on QlikView Layout & Visualizations.
Getpossiblecount() returns the current number of possible values in a field, however since null is not value per se it is not included in the count.
How can one get a count of possible values, including null ?
Best Regards, Bill
Go to Solution.
A trick just hits mind. Null count would be always one, right? May be you can add 1 to count conditionally like:
NullCount( Distinct Field)+GetPossibleCount(Field)
have you tried NullCount function ?
If you wish to count the null values you can probably do this some other way.
If they are a field in a fact table, you cannot really know whether each null is unique or not. If the nulls are in a reference table there must be some lind of other field for reference to count.
In either case it is quite often easier to add a field to the table with the content of 1 and then use sum ....
I hope this is useful
NullCount( Distinct Field)+GetPossibleCount(Field) works perfectly.
Many Thanks, Bill