Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we clean the data set i.e. excel for null observations before using it for visualization?
I have a worksheet survey where there are some observations with null value. I want to remove those observations in qlikview. Can you please suggest me some way to do this?
There's a pretty good write up here.
As a quick pointer I usually use "if(Len(Trim(Field))>0,Field,NullSubstitute)" for text fields or "Alt(Field,NullSubstitute)" for numeric fields. The NullAsValue functionality will help for more widespread null issues.
Hi Ben,
Thanks for the reply. I am currently using set analysis to handle this. But my question is at the time of data load, can we eliminate some rows if there is no data available?
Pinaki
Sure just use a where clause:
Load
Field1,
Field2,
Field3
From SomeFile.qvd (qvd)
Where Len(Trim(Field1))>0
You could also use the Isnull() function, but I prefer the Len(Trim( method as it also eliminates zero length strings which would pass the Isnull() check.