show blank where there is no possible values

[JMAROUF]

Hi,

Can anyone help to show blank instead of hyphen where there is no possible values, the product 4 has no row in the fact, so it shows a hyphen in the straight table:

fact:
LOAD * inline [
product,tag,date,key
P_1,T_1,01/01/2001,P_101/01/2001
P_1,T_1,15/01/2001,P_115/01/2001
P_1,T_1,31/01/2001,P_131/01/2001
P_2,T_2,01/02/2002,P_201/02/2002
P_3,T_1,01/03/2003,P_301/03/2003
];

product:
LOAD * inline [
product,name
P_1,product_1,
P_2,product_2
P_3,product_3
P_4,product_4
];

date:
LOAD * inline [
date,month,year
01/01/2001,1,2001
15/01/2001,1,2001
31/01/2001,1,2001
01/02/2002,2,2002
01/03/2003,3,2003
];

 Thanks in advance 

[abhijitnalekar]

Hi @JMAROUF ,

Is it necessary to show the P4 in the table?

you can get rid of that row if you join the table in the script.

date:
LOAD * inline [
date,month,year
01/01/2001,1,2001
15/01/2001,1,2001
31/01/2001,1,2001
01/02/2002,2,2002
01/03/2003,3,2003
];

fact:
LOAD * inline [
product,tag,date,key
P_1,T_1,01/01/2001,P_101/01/2001
P_1,T_1,15/01/2001,P_115/01/2001
P_1,T_1,31/01/2001,P_131/01/2001
P_2,T_2,01/02/2002,P_201/02/2002
P_3,T_1,01/03/2003,P_301/03/2003
];

left join(fact)
product:
LOAD * inline [
product,name
P_1,product_1,
P_2,product_2
P_3,product_3
P_4,product_4
];

[vinieme12 · Accepted solution]

You need to handle it in expression using if()

Calculated dimensions

=Aggr(If(date,date,' '), product,date)

=Aggr(If(tag,tag,' '), product,tag)

[JMAROUF]

Thank you @abhijitnalekar , I can't join the table. 

Thaks @vinieme12 , It works just for date but not for tag.

[luiferva]

Hola JMAROUF  si no necesitas mostrar los valore nulos le puedes presionar 

y listo se quitan los valores nulos.

[JMAROUF]

Thanks @luiferva ,

I'm looking to show the value of dimension, I can'T hide it.