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

tommaso26 — Mon, 24 Oct 2022 09:51:16 GMT

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?

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

Mark_Little — Mon, 24 Oct 2022 10:34:10 GMT

You would have to expression for the Dimension,

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

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

vinieme12 — Tue, 25 Oct 2022 03:15:16 GMT

try below calculated dimension

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

topic Re: Handle Null Values as a result from associative engine behavior between tables in App Development

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

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

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