topic How to format a number in HTML output file with commas? in QlikView

How to format a number in HTML output file with commas?

Wed, 14 Dec 2011 16:46:57 GMT

I have a straight table chart with numbers formatted as #,##0. When the chart is output to an HTML file using the ExportEx or ExportHTML statement in a macro, the amount in the cell (TD tag) is not output with the commas inserted. Is there an easy solution for this?

Thanks

How to format a number in HTML output file with commas?

fosuzuki — Thu, 15 Dec 2011 23:34:11 GMT

Hi,

one not-so-good workaround is to create another similtar table with the correct format, and use it in the export macro. You can minimize it and hide it under a text box with white background... difficult to maintain though...

How to format a number in HTML output file with commas?

Thu, 29 Dec 2011 16:13:36 GMT

Just figured it out. It turns out that the Num() function doesn't respect the regional settings like the manual says it should. But wrapping the expression, e.g., Sum(Field1) in a Num() function with all parameters specified, like Num(Sum(Field1),'#,##0','.',',') works.