<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article Handling Decimal value in String type input parameter in Official Support Articles</title>
    <link>https://community.qlik.com/t5/Official-Support-Articles/Handling-Decimal-value-in-String-type-input-parameter/ta-p/1783428</link>
    <description>&lt;P&gt;&lt;SPAN&gt;When entering a decimal value that ends in one or more zeroes, the trailing zeroes will be removed if the value is entered in an input field that expects a string value. &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;To prevent this, add an &lt;/SPAN&gt;&lt;FONT face="courier new,courier"&gt;" " &lt;/FONT&gt;&lt;SPAN&gt;to your value.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Example: If you enter the number &lt;FONT face="courier new,courier"&gt;30.70&lt;/FONT&gt; in a string input field, the last &lt;FONT face="courier new,courier"&gt;0&lt;/FONT&gt; will be trimmed automatically and the output will be &lt;FONT face="courier new,courier"&gt;30.7&lt;/FONT&gt;. In some cases, this last zero is needed for example, for a project or product code. Hence you need to add &lt;FONT face="courier new,courier"&gt;" "&lt;/FONT&gt; to your value so that the last&lt;FONT face="courier new,courier"&gt; 0&lt;/FONT&gt; will not be trimmed.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;When entering &lt;FONT face="courier new,courier"&gt;0&lt;/FONT&gt; as a value for an input field, encapsulate it in double-quotes &lt;FONT face="courier new,courier"&gt;"0"&lt;/FONT&gt;, else it will be considered as null. Also you can use "&lt;FONT face="courier new,courier"&gt;To text&lt;/FONT&gt;" formula to convert the number to string.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;&lt;A href="https://help.blendr.io/docs/using-formulas-in-placeholders" target="_self"&gt;Click here&lt;/A&gt;&amp;nbsp; to find the formula placeholders.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Before adding &lt;FONT face="courier new,courier"&gt;" "&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_0-1613566383292.png" style="width: 180px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49258i0BF39B2E685CEE5B/image-dimensions/180x67?v=v2" width="180" height="67" role="button" title="Madhushree_BP_0-1613566383292.png" alt="Madhushree_BP_0-1613566383292.png" /&gt;&lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_1-1613566409812.png" style="width: 265px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49259i3F5964EC93A5D58B/image-dimensions/265x47?v=v2" width="265" height="47" role="button" title="Madhushree_BP_1-1613566409812.png" alt="Madhushree_BP_1-1613566409812.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;After adding&amp;nbsp; &lt;FONT face="courier new,courier"&gt;" "&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_2-1613566451418.png" style="width: 183px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49260iE3CAA112BA4DD9DD/image-dimensions/183x81?v=v2" width="183" height="81" role="button" title="Madhushree_BP_2-1613566451418.png" alt="Madhushree_BP_2-1613566451418.png" /&gt;&lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_3-1613566479908.png" style="width: 255px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49261i8DA65CAF14CA9088/image-dimensions/255x49?v=v2" width="255" height="49" role="button" title="Madhushree_BP_3-1613566479908.png" alt="Madhushree_BP_3-1613566479908.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 28 Jul 2021 20:42:56 GMT</pubDate>
    <dc:creator>Madhushree_BP</dc:creator>
    <dc:date>2021-07-28T20:42:56Z</dc:date>
    <item>
      <title>Handling Decimal value in String type input parameter</title>
      <link>https://community.qlik.com/t5/Official-Support-Articles/Handling-Decimal-value-in-String-type-input-parameter/ta-p/1783428</link>
      <description>&lt;P&gt;&lt;SPAN&gt;When entering a decimal value that ends in one or more zeroes, the trailing zeroes will be removed if the value is entered in an input field that expects a string value. &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;To prevent this, add an &lt;/SPAN&gt;&lt;FONT face="courier new,courier"&gt;" " &lt;/FONT&gt;&lt;SPAN&gt;to your value.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Example: If you enter the number &lt;FONT face="courier new,courier"&gt;30.70&lt;/FONT&gt; in a string input field, the last &lt;FONT face="courier new,courier"&gt;0&lt;/FONT&gt; will be trimmed automatically and the output will be &lt;FONT face="courier new,courier"&gt;30.7&lt;/FONT&gt;. In some cases, this last zero is needed for example, for a project or product code. Hence you need to add &lt;FONT face="courier new,courier"&gt;" "&lt;/FONT&gt; to your value so that the last&lt;FONT face="courier new,courier"&gt; 0&lt;/FONT&gt; will not be trimmed.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;When entering &lt;FONT face="courier new,courier"&gt;0&lt;/FONT&gt; as a value for an input field, encapsulate it in double-quotes &lt;FONT face="courier new,courier"&gt;"0"&lt;/FONT&gt;, else it will be considered as null. Also you can use "&lt;FONT face="courier new,courier"&gt;To text&lt;/FONT&gt;" formula to convert the number to string.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;&lt;A href="https://help.blendr.io/docs/using-formulas-in-placeholders" target="_self"&gt;Click here&lt;/A&gt;&amp;nbsp; to find the formula placeholders.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Before adding &lt;FONT face="courier new,courier"&gt;" "&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_0-1613566383292.png" style="width: 180px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49258i0BF39B2E685CEE5B/image-dimensions/180x67?v=v2" width="180" height="67" role="button" title="Madhushree_BP_0-1613566383292.png" alt="Madhushree_BP_0-1613566383292.png" /&gt;&lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_1-1613566409812.png" style="width: 265px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49259i3F5964EC93A5D58B/image-dimensions/265x47?v=v2" width="265" height="47" role="button" title="Madhushree_BP_1-1613566409812.png" alt="Madhushree_BP_1-1613566409812.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;After adding&amp;nbsp; &lt;FONT face="courier new,courier"&gt;" "&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_2-1613566451418.png" style="width: 183px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49260iE3CAA112BA4DD9DD/image-dimensions/183x81?v=v2" width="183" height="81" role="button" title="Madhushree_BP_2-1613566451418.png" alt="Madhushree_BP_2-1613566451418.png" /&gt;&lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_3-1613566479908.png" style="width: 255px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/49261i8DA65CAF14CA9088/image-dimensions/255x49?v=v2" width="255" height="49" role="button" title="Madhushree_BP_3-1613566479908.png" alt="Madhushree_BP_3-1613566479908.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 28 Jul 2021 20:42:56 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Official-Support-Articles/Handling-Decimal-value-in-String-type-input-parameter/ta-p/1783428</guid>
      <dc:creator>Madhushree_BP</dc:creator>
      <dc:date>2021-07-28T20:42:56Z</dc:date>
    </item>
  </channel>
</rss>

