Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Handling Decimal value in String type input parameter

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Madhushree_BP
Support
Support

Handling Decimal value in String type input parameter

Last Update:

Jul 28, 2021 4:42:56 PM

Updated By:

Jamie_Gregory

Created date:

Feb 17, 2021 11:01:50 PM

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.

To prevent this, add an " " to your value.

Example: If you enter the number 30.70 in a string input field, the last 0 will be trimmed automatically and the output will be 30.7. In some cases, this last zero is needed for example, for a project or product code. Hence you need to add " " to your value so that the last 0 will not be trimmed.

When entering 0 as a value for an input field, encapsulate it in double-quotes "0", else it will be considered as null. Also you can use "To text" formula to convert the number to string.

Click here  to find the formula placeholders.

Before adding " "

Madhushree_BP_0-1613566383292.png                  Madhushree_BP_1-1613566409812.png

After adding  " "

Madhushree_BP_2-1613566451418.png                Madhushree_BP_3-1613566479908.png

 

 

Tags (2)
Labels (2)
Version history
Last update:
‎2021-07-28 04:42 PM
Updated by: