format values in word template

[curiousfellow]

In a Word template I created several tables. Some values are for example like 15,123456 and I want to show them as 15,12

I unchecked "keep source formats" and use Format .

I tried several options like ##,## or ##.## and "##.##" but they don't seem to have effect.

Should it be possible to format values ?

[Ruggero_Piccoli]

Hi,

As workaround I suggest to create a column (or modify an existing one) buy exporting it as a formatted text.

Best Regards,

Ruggero

[curiousfellow]

I am afraid that I have to go that way indeed. I would prefer to use the format in Qlik, but than I can not fix the columnwidth of the table in Word. (I want the column width of three tables to be equal.

[Ruggero_Piccoli]

Hi,

You can use the Qlik formats, QlikView NPrinting will do its best efforts to copy the same formats in the final report. In this case you need to keep the Keep source format option flagged.

To set the columns width and other look and feel parameters you can use the Word Table Tools. 

If you need a very fine tuning of the report look and feel I suggest you to evaluate to develop a PixelPerfect report.

Best Regards,

Ruggero

[NitinK7]

Hi 

Try to below expression

=Num(Values,'#,##')

Regards,

Nitin.