Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I hope some guru could help on this issue.
I am exporting a pivot table to html and sending it to an email. The formatting is loss but only the comma separator is missing.
Inspected the regional settings, the whole format on configuration and using also the num( expression, '#,###.##')
Nothing works.
Please help me to discover this is not a bug on QlikView.
Thank you!
HV
User Preferences-> Export -> Number Formating
Have a look at the User Preferences... Export / Default Export Options ....
Thank you for your response Mario,
But also this not work too.
HV
Did you select Full Formatting in the Number Formatting option?.
Yes Mario. Full Formatting and and also did a num(expression,'$#,###.#') for each column on the pivot table.
I got a dollar sign on the exported html, but the comma is stripped.
Thank you Petter for your help.
But I did all the combinations and review also my regional settings and this is not working.
The comma is deleted as thousand separator.
Thx
attached a sample doc which I export to html, take a look at its default configuration. I'm not sure if I understood. Your issue is with the formatting itself right?. I could export the document along with the Sales column and it looks just like the Desktop's version.
I also tried with the Pivot version and it works, it keeps its original numeric format. I believe that If you make a test to export it manually from desktop as HTML and find that it looks good, then it is no the export step itself, it might bee the macro or program you are using that is sending it out along with the Email message.
Thank you for your nice responses.
The exporting test on the desktop works correctly, showing numbers with the comma separator as this example : $123,123.12
But running the VB Script macro with the following sentences :
SET objTable = ActiveDocument.GetSheetObject(ObjId)
objTable.ServerSideExportEx "C:\Aplicaciones\Reportes\OutPut\"& ResName &".html" , ";", 0
Shows the same number as $123123.12
The comma separator is missing.
The export preferences are correct as mentioned by Petter, The regional settings on the server for numerical data are correct.
Any Idea how to solve this?
Thank you very much for your time.