topic Re: nPrinting custom number format in chart in Qlik NPrinting

nPrinting custom number format in chart

1302aman — Tue, 07 Jan 2020 15:04:50 GMT

I need seprator for Thousand, Million , Billion in Pixel perfect nprinting report.

For Example in chart it should print like below

2543560000 2.5B

8551200 8.6M

56788 56.8K

Currenlty I can use only {V:#,}k. I am not sure how to use it conditionally. My values are varying for every merhchant and I need to use something conditioannly to take care of the vaues.

Re: nPrinting custom number format in chart

Frank_S — Tue, 07 Jan 2020 15:56:55 GMT

Updated:

I found this but haven't tested it.

https://stackoverflow.com/questions/11731996/string-format-numbers-thousands-123k-millions-123m-billions-123b

The most success I've had is using formatting for K only using the following custom format in MS Excel:

#,K

See image below:

Re: nPrinting custom number format in chart

Frank_S — Tue, 07 Jan 2020 16:00:30 GMT

#,K

Also works as a custom currency format as well in PxP.

Re: nPrinting custom number format in chart

1302aman — Tue, 07 Jan 2020 16:27:41 GMT

This will conver only in thousand but I need to convert it conditionally like if number is greater than 1000 then convert it in K else no conversion. Also if grrater than 1000000 then convert in Million.

Re: nPrinting custom number format in chart

Frank_S — Tue, 07 Jan 2020 17:17:46 GMT

There is a scripting tool that may help you to achieve this formatting requirement.

Perhaps you could check the Dev Express knowledge base as this appears to be an advanced scripting function that 'might' be possible. I've placed a couple links here for you. (Dev Express is the platform backbone that PxP is built on.

https://search.devexpress.com/?m=Documentation&f=0&q=format%20Billions%20or%20millions%20or%20thousands&ref=doc

https://js.devexpress.com/Documentation/ApiReference/Common/Object_Structures/format/

Or perhaps someone else here in the NP community might have a more specific solution as well.

Kind regards...

Re: nPrinting custom number format in chart

1302aman — Tue, 07 Jan 2020 17:58:16 GMT

I wish i could use this but unfortunately nprint does not allow this else this could be achive easily. My problem is specific to Nprint pixel perfect report.

Re: nPrinting custom number format in chart

Lech_Miszkiewicz — Wed, 08 Jan 2020 23:05:24 GMT

My approach would be to configure another column in source table in Qlik to indicate wheter you need to use M, K or any other format and at the same time already in Qlik devide numbers by 1000000,1000 or whatever you need.. Then in nprinting pixel perfect you can use formatting rules to conditionally (based on additional column i mentioned above) assign number format.

So this is achievable, but requires proper planning on both ends - QlikView / Qlik Sense and Nprinting

Re: nPrinting custom number format in chart

1302aman — Thu, 09 Jan 2020 10:46:58 GMT

I also though the same but I need to Identify those with 'K' or 'M'. Now second challenge is that NetPrinting does not accept values in string and again I need to change them in Number and rounded back to the same issue. See screen shot below. I need to handle it from Nprint in the same way we do in any app like Qliksense or excel.

Currently I have set it up in the Thousands but few if my merchants have in Millions and few of them are in Thousands and I want it to behave dynamically instead of showing only in thousands.

Re: nPrinting custom number format in chart

Lech_Miszkiewicz — Thu, 09 Jan 2020 10:50:34 GMT

Hi... this is not what i meant

1 extra column needs to know if it is M K B or anything else (without actual value). This column will be used in Pixel perfect to format column where values already divided by 1000000, 1000, etc (but without format, so still numbers would be shown)

Re: nPrinting custom number format in chart

Lech_Miszkiewicz — Thu, 09 Jan 2020 11:04:50 GMT

so in qliksense you would have following table:

you would use Value for NPrinitng column to produce values in NPrinitng Pixel Perfect template and based on Conditional format you woul add M B K formats or any other format you need

Re: nPrinting custom number format in chart

Lech_Miszkiewicz — Thu, 09 Jan 2020 11:08:23 GMT

Correction:

Apologies - I got fixed up on pixel perfect tables (not charts), and in tables my solution would work as it does not need reference to scale (and also your solution would work where you already created values in Qlik Sense with M K B etc...)

You are right - with charts it needs actual values to allow for reference to scales and properly plot bars/lines height...

Re: nPrinting custom number format in chart

1302aman — Wed, 15 Jan 2020 09:53:45 GMT

Let me try in that way, Thanks for answer this

Re: nPrinting custom number format in chart

JonnyPoole — Wed, 15 Jan 2020 14:53:26 GMT

Here are some steps and techniques to dynamically change the number formatting per filter or variable that will work in Nprinting too.