Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dwfiv327
Contributor II
Contributor II

Mapping table and blank fields

I am trying to use a mapping table to decode user entered data into categories.  If the user fails to enter any data, it needs to map to 'Unknown'.  Try as I might, I cannot get any value mapped to a blank field.  I have tried:

null(),unknown

'',unknown     (single quotes with nothing in between)

"",unknown      (double quotes with nothing in between)

,unknown     (nothing in front of the comma)

Is it possible to map a blank field at all?

If the user enters at least a blanks space, the mapping table picks that up just fine.

If I load the map table as a stand alone table and do a join on this field, it works, but I would prefer to use a map table.

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

1 Reply
Chanty4u
MVP
MVP