blank value '-' change to static value of "OTHER".

[shekkyBoi]

Hi,

I have a report below, I have attached the main area of issue.

When I run the Load I have "-" in my table, which is not clickable, I am assuming its nulls? 

My question is, how do I turn the "-' to say "others" instead of -?

CRM_MAP:
 
Mapping

LOAD * INLINE [

Association, CODE

1, a

2, b

3, b

4, c

5, d

];




Intermediary :
LOAD

Association,
(there are other fields as well. But the association is the main field of concern ).

FROM
$(vDataPath)test.qvd
(qvd)where PrimaryLoc='Yes';

[njc_96]

Hi @shekkyBoi ,

Please use the below lines before loading the table. These lines converts the nulls into values

NullAsValue Associaton;  

Set NullValue = 'Others'; 

Reference Link:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptR...

Hope this solution helps you!

Thanks!