topic Nprinting number format in Qlik NPrinting

Nprinting number format

ronaldwang — Tue, 20 Jun 2017 07:30:17 GMT

Hi,

When I try to export data into excel (using the not keep formatting) and I want to show the negative number in red so I use format like "#,##0;[Red]-#,##0". but the result is changed to #,##0;__-#,##0. Anyone had similar experience and what is the fix? thanks

Re: Nprinting number format

ogster1974 — Tue, 20 Jun 2017 08:37:49 GMT

Have you tried using the conditional formatting built into excel?

Layout your table cells in the sheet and highlight the data cells you want to conditionally format.

Re: Nprinting number format

devarasu07 — Tue, 20 Jun 2017 08:48:46 GMT

Hi,

Why don't you do your conditional text column in qlikview object itself (refer to sample attachment). then nprint easy to capture the format.

try to put like below in your expression (measure filed --> under text color)

if(sum(Sales)>0,Black(),Red())

Note:

if you really wanted to do in nprint custom format like below

#.##0,0;(#.##0,0)

Re: Nprinting number format

ronaldwang — Tue, 20 Jun 2017 23:46:20 GMT

thanks Devarasu and Andy.

Re: Nprinting number format

Lech_Miszkiewicz — Wed, 21 Jun 2017 00:20:30 GMT

Hi Ronald,

When you want to format your cells in XLS you must use "Excel Conditional Formatting" for cells you want to apply collors to!

see screenshots (i did them quickly in Excel, but you would have to do it oin NPrinting designer - template editor and conditional formatting will be applied to the tag representing your number , like: <nodeXX>:

regards

Lech

Re: Nprinting number format

ronaldwang — Wed, 21 Jun 2017 00:23:53 GMT

Thanks Lech.

I used to open excel template directly and edit from there as it works quicker. and from your post seems like this is not the safest way to edit.

Re: Nprinting number format

Lech_Miszkiewicz — Wed, 21 Jun 2017 00:27:21 GMT

That is still fine.

Just remind me Ronald - are you on version 16 or 17 of NPrinting. In version 16 it was very easy to find and edit template where in version 17 template is tailer in repository files and it has self assigned GUID id which may be difficult to find among other files.

regards

Lech

Re: Nprinting number format

ronaldwang — Wed, 21 Jun 2017 00:32:57 GMT

Hi Lech,

I am using 16.2 and easy to edit the template, just when the template file gets bigger, the speed to edit in designer is very slow.

Re: Nprinting number format

Lech_Miszkiewicz — Wed, 21 Jun 2017 00:55:47 GMT

no worries then

did you actualy solve your issue raised in this topic - If so please mark correct answers?

cheers

Lech