I am working in Qlik Sense Desktop (June 2017). I have an app in which I am rounding certain fields to 2 decimal places. After the rounding (via Round(field, 0.01)), I have noticed that some numbers don't retain 2 decimal places. For example, if the rounded number is something like '3.00', the number gets displayed as '3'. If the rounded number is something like '3.10', the number gets displayed as '3.1'. How can I keep the trailing zeros, to always have 2 decimal places displayed after the number?
I did (with the minor tweak of '#,##0.00 ', as I am American.) Your solution works on the data from the inline load. However, it doesn't work on my actual data. That is why I posted a more detailed version of my script. I'm wondering if it has something to do with the fact that my data comes from a resident load. Perhaps the rounding and formatting need to first be applied to the data source (i.e., to table T1).
Thank you. This is what I needed. I wasn't aware that I had to re-name the fields to a different name, drop the original fields (via Drop Fields), and then switch the field names back to the original names.