topic Re: Percentages in N Printing in Qlik NPrinting

Percentages in N Printing

paul_ripley — Thu, 25 Oct 2018 10:27:14 GMT

Hello

I have a table in QV that uses the expression

num((Variance / [6 month average]) ,'##0%;(##0%);-')

This brings back the correct amounts

I then import it into N Printing

But the variances show as below. Does N Printing not support percent formats when using a powerpoint template?

Can anyone sugest how to get round this

Thanks

Paul

Re: Percentages in N Printing

Ruggero_Piccoli — Thu, 25 Oct 2018 12:06:32 GMT

Hi,

PowerPoint cannot change the format of a number so you have to export it as a formatted string just by changing the formula you posted.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Percentages in N Printing

paul_ripley — Thu, 25 Oct 2018 15:36:42 GMT

Hi Ruggero

What is wrong with num((Variance / [6 month average]) ,'##0%;(##0%);-')

Does that not format the number as a percentage? What change would I need to make?

Thanks

Paul

Re: Percentages in N Printing

lcontezini — Thu, 25 Oct 2018 16:35:04 GMT

just check the box "keep source formats"

Re: Percentages in N Printing

Lech_Miszkiewicz — Fri, 26 Oct 2018 00:30:37 GMT

Hi Paul,

num() function applies Qlik number formatting in Qlik on top of underlying numbers. It is not changing the actual value to string as it retains the details down to all decimal places etc...

The solution would be to apply "text" function on top of it to completly , although i hate that solution!

text(num((Variance / [6 month average]) ,'##0%;(##0%);-'))

cheers

Lech