topic Re: How to format decimals using a format pattern on a report in QlikView

How to format decimals using a format pattern on a report

cliff_clayman — Tue, 25 Apr 2017 15:37:47 GMT

I have a few decimal fields from a SQL table that I need to format in the report. The user does not want to see the decimals where the value is a round number. For example, currently a value displays as 100.00 and the user wants to see 100. However, if the value is 123.45, then I need it to display as 123.45. Can I handle this on the report? I know I can use the Number Format Settings in the Document Properties, but I am not sure what the format syntax would be.

Re: How to format decimals using a format pattern on a report

Peter_Cammaert — Tue, 25 Apr 2017 16:11:43 GMT

If you use Expression Default from the Numbers tab, you should get integers when no decimals are to be shown, and a floating point value in all other cases.

Re: How to format decimals using a format pattern on a report

cliff_clayman — Tue, 25 Apr 2017 16:13:08 GMT

These aren't expressions. They are just dimensions I pulled onto a straight table.

Re: How to format decimals using a format pattern on a report

Peter_Cammaert — Tue, 25 Apr 2017 16:19:25 GMT

Then replace them in your Chart Properties with a Calculated Dimension and enter an expression like:

=num([Your Dimension Field])