Handle Null Values as a result from associative engine behavior between tables

[tommaso26]

Hello everyone,

I am having troubles handling Null values when they are a result of the associative engine between tables.

For example, I define the following two tables:

Table_Customer:
LOAD * Inline [
ID_Cust , Customer , Age
01 , Luke , 22
02 , John , 32
03 , Marius , 24
04 , Linda , 30
];

Table_Sales:
LOAD * Inline [
ID , Customer , Value , Country
004 , Marius , 15, IT
015 , Luke , 25, ES
022 , Brenda , 40, IT
030 , Matt , 20, FR
];

The Table_Customer holds data about four customers, whereas the Table_Sales holds data about Sales.  The tables will be joined together by the Qlik associative engine based on the "Customer" field, which is common between the two tables.

In the Analyze tab I want to display Customers and Age, however I don't have Age info for all the customers, therefore I get the following result

What I am trying to do is to avoid displaying the null value by defining an arbitrary value in the Data Load Editor (or example using the NullAsValue function) as shown below.

Is there a way to define an arbitrary value for a field that comes as a result of the associative engine, without joining the tables together?

[Mark_Little]

You would have to expression for the Dimension,

Something like IF(ISNULL(AGE), 'NA', AGE)

[vinieme12]

try below calculated dimension

=aggr(if(Age,Age,'NA'),Customer)