topic How to eliminate nulls while using applymap function. in QlikView https://community.qlik.com/t5/QlikView/How-to-eliminate-nulls-while-using-applymap-function/m-p/65226#M788185 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have a scenario where the data is loading from two different files with&nbsp; indirect relation ,used applymap and made a relation between two tables.</P><P></P><P>But the issue is some of the data is blank ,tired to give same blank in other file as well but the data is not reflecting properly.</P><P>it is taken as '-' category when I build a chart.</P><P></P><P>Also&nbsp; some of the data was 'NA' ,so I want to map blanks and NA as one output category </P><P></P><P>Request your help to resolve the issue.</P><P></P><P>Please find the attached source file and qvw.</P><P></P><P></P><P>Thanks In advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT kvr9 2020-11-25T16:16:04Z How to eliminate nulls while using applymap function. https://community.qlik.com/t5/QlikView/How-to-eliminate-nulls-while-using-applymap-function/m-p/65226#M788185 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have a scenario where the data is loading from two different files with&nbsp; indirect relation ,used applymap and made a relation between two tables.</P><P></P><P>But the issue is some of the data is blank ,tired to give same blank in other file as well but the data is not reflecting properly.</P><P>it is taken as '-' category when I build a chart.</P><P></P><P>Also&nbsp; some of the data was 'NA' ,so I want to map blanks and NA as one output category </P><P></P><P>Request your help to resolve the issue.</P><P></P><P>Please find the attached source file and qvw.</P><P></P><P></P><P>Thanks In advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-eliminate-nulls-while-using-applymap-function/m-p/65226#M788185 kvr9 2020-11-25T16:16:04Z