topic Re: format values in word template in Qlik NPrinting

format values in word template

curiousfellow — Tue, 17 Mar 2020 20:40:38 GMT

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 ?

Re: format values in word template

Ruggero_Piccoli — Thu, 12 Mar 2020 15:45:27 GMT

Hi,

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

Best Regards,

Ruggero

Re: format values in word template

curiousfellow — Fri, 13 Mar 2020 09:25:51 GMT

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.

Re: format values in word template

Ruggero_Piccoli — Fri, 13 Mar 2020 10:31:37 GMT

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

Re: format values in word template

NitinK7 — Fri, 13 Mar 2020 15:08:38 GMT

Try to below expression

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

Regards,

Nitin.