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: 
n1ef5ng1
Creator
Creator

Data Cleaning

Hi gurus,

I am trying to create table that shows any data that need to 'clean'. Data cleaning in short. Say example this particular bus travel to a bus_terminal_code call RUEWW. All my bus_terminal_code will link to bus_region_code. As this RUEWW is not a recgonize code, therefore the bus_region_code show a '-' as the output. I am trying to display a table where it will show all the '-' as output. Thus, user will know which data that needs to touch up.

I tried ways such as if(bus_region_code = '-' or bus_region_code = null(), 'SHOW')) but it does not work, any gurus can help

1 Reply
forte
Partner - Creator
Partner - Creator

Hi Ben :

Null Value is not selectable, and cannot be used also on any Set Analysis as you suggest. You need to modafy your load script in order to "mark" those wrong values with an especial value (you can call it ERROR for example).

Then you'll be able to get all the ERROR related rows.

Hope it helps

Regardas