Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data cleansing in qlikview


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?

3 Replies
bme
Partner - Contributor III
Partner - Contributor III

There's a pretty good write up here.

NULL handling in QlikView

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.

Not applicable
Author

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

bme
Partner - Contributor III
Partner - Contributor III

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.