Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
meenakshi_m
Contributor III
Contributor III

handling null values in dimension and replace by value other .

Hi ,

I have 2 tables one is static data and other date with details.Both are connected with common field. when i try to pull resident i get null value in resident which i want to name it as  other.Qvd file attached. appreciate help

meenakshi_m_0-1614702240139.png

meenakshi_m_1-1614702267661.png

 

 

1 Solution

Accepted Solutions
Ksrinivasan
Specialist
Specialist

hi,

Use Applymap function with Mapping load,

TAB1:

Mapping Load

Student,

Resident

from:

 

Tab2:

Load

Student,

Applymap('Tab1',Student,'Others') as Resident,

mark1,

Mark2

From

 

ksrini

View solution in original post

2 Replies
Ksrinivasan
Specialist
Specialist

hi,

Use Applymap function with Mapping load,

TAB1:

Mapping Load

Student,

Resident

from:

 

Tab2:

Load

Student,

Applymap('Tab1',Student,'Others') as Resident,

mark1,

Mark2

From

 

ksrini

View solution in original post

meenakshi_m
Contributor III
Contributor III
Author

Thanks yes this is working.