topic Sales with text and Number - Dual in QlikView https://community.qlik.com/t5/QlikView/Sales-with-text-and-Number-Dual/m-p/1437620#M431731 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>what are the effective ways to set Text to the Sales Field ?</P><P></P><P>Eg. if(Isnull(Sales), 'N/A', Sales) as Dual_Sales</P><P></P><P>and in the front end chart, </P><P>like below</P><P></P><TABLE border="1" class="jiveBorder" height="95" style="border: 1px solid rgb(0, 0, 0); width: 352px; height: 97px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">N/A</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">200</TD></TR></TBODY></TABLE><P></P><P>THanks</P><P>Renji</P></BODY></HTML> Mon, 18 Sep 2017 20:12:18 GMT renjithpl 2017-09-18T20:12:18Z Sales with text and Number - Dual https://community.qlik.com/t5/QlikView/Sales-with-text-and-Number-Dual/m-p/1437620#M431731 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>what are the effective ways to set Text to the Sales Field ?</P><P></P><P>Eg. if(Isnull(Sales), 'N/A', Sales) as Dual_Sales</P><P></P><P>and in the front end chart, </P><P>like below</P><P></P><TABLE border="1" class="jiveBorder" height="95" style="border: 1px solid rgb(0, 0, 0); width: 352px; height: 97px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">N/A</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">200</TD></TR></TBODY></TABLE><P></P><P>THanks</P><P>Renji</P></BODY></HTML> Mon, 18 Sep 2017 20:12:18 GMT https://community.qlik.com/t5/QlikView/Sales-with-text-and-Number-Dual/m-p/1437620#M431731 renjithpl 2017-09-18T20:12:18Z Re: Sales with text and Number - Dual https://community.qlik.com/t5/QlikView/Sales-with-text-and-Number-Dual/m-p/1437621#M431732 <HTML><HEAD></HEAD><BODY><P>Maybe use NULLASVALUE and NULLVALUE as in</P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ValueHandlingVariables/NullValue.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ValueHandlingVariables/NullValue.htm">NullValue ‒ QlikView</A></P></BODY></HTML> Mon, 18 Sep 2017 20:56:05 GMT https://community.qlik.com/t5/QlikView/Sales-with-text-and-Number-Dual/m-p/1437621#M431732 swuehl 2017-09-18T20:56:05Z Re: Sales with text and Number - Dual https://community.qlik.com/t5/QlikView/Sales-with-text-and-Number-Dual/m-p/1437622#M431733 <HTML><HEAD></HEAD><BODY><P>Hi Renjit,</P><P></P><P>As an advice we recomend try to filter the data since de extraction process, since the source data. any way many qlik objects bring with the option "Include Null values" unckeck this option.</P><P></P><P>regards.</P></BODY></HTML> Mon, 18 Sep 2017 21:48:18 GMT https://community.qlik.com/t5/QlikView/Sales-with-text-and-Number-Dual/m-p/1437622#M431733 lgutierrez 2017-09-18T21:48:18Z