Discussion board where members can get started with QlikView.
i want to check in each filed null count how can i check this?
is there any specific method ?
which kind of file are you referring. Please provide sample.
You can use =NullCount( <FieldName> ) to count null values for a specific field.
its not working tried
Are you sure that there are real NULL values instead of " "? An empty value is still a value, which is different from NULL.
Can you try this:
Show us some sample data please. Also you can try below:
=NullCount(Tot) + Count(If(Len(Trim(Tot))=0,Tot))
So that it will count null and spaces both.
Try set analysis with -=
thanks all its working this