Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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
New Contributor III

Re: Data cleansing in qlikview

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

Re: Data cleansing in qlikview

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
New Contributor III

Re: Data cleansing in qlikview

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.

Community Browser