topic Re: Calculation in master measure expression in Qlik NPrinting

Calculation in master measure expression

Slindheim — Fri, 26 Mar 2021 11:33:06 GMT

With the latest update of Qlik Sense it is now possible to use Master measures in expressions.

But there is a problem in NPrinting, or I just don't see a mistake on my side.

Sales = sum(Sales) works as a Master Measure in NPrinting -> [Sales]

But if I am using a calculation, NPrinting only shows '-' in every row.

For example: Perc.Change = [SalesThisYear] - [SalesLastYear] / [SalesLastYear]

If I am using this formula, it works in NPrinting: Perc.Change=sum(SalesThisYear)-sum(SalesLastYear)/sum(SalesThisYear)

Then, Perc.Change won't work in NPrinting.

The column in the Qlik Table shows the correct values. So, it seems like NPrinting cannot work with nested/boxed expressions from Qlik. Is that right, or am I doing something wrong?

Re: Calculation in master measure expression

Frank_S — Tue, 06 Apr 2021 22:26:23 GMT

I believe the following article still applies to current versions of NPrinting.

Please have a look.

https://support.qlik.com/articles/000042515

Kind regards...

Re: Calculation in master measure expression

Arlind — Wed, 20 Oct 2021 11:36:26 GMT

Hello Frank,

I am running into the same issue, with Master Measures in expressions not being supported by NPrinting. It seems your link to the support case is dead.

Is this something that can be configured to work?

Best regards,

Arlind

Re: Calculation in master measure expression

Frank_S — Wed, 20 Oct 2021 14:21:23 GMT

R&D is working on providing overall clarity on the subject so the article has been removed from publication.

For now, you can try to un-linking as per the following article and video tutorial.

Then use the object ID of the unlinked Item in your NPrinting Report.

Kind regards...

Re: Calculation in master measure expression

Lech_Miszkiewicz — Thu, 21 Oct 2021 03:03:26 GMT

Hi,

Steps described by Frank are not going to help you - If I understand your issue correctly this is the same as this:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Using-master-measures-that-reference-other-master-measures-in/m-p/1849430#M33860

and this:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Gauge-from-Qlik-sense-into-Nprinting/td-p/1839212

and for now there is no known solution other than not using master measures within other master measures definitions. I know it has a huge impact if you have designed everything using that method.

sorry

Re: Calculation in master measure expression

pabloviera — Fri, 05 Nov 2021 09:35:26 GMT

Well, I ended up here after trying to clean up my measures and finding I'm not getting values in the NPrinting report. Time to roll back the work.

Another gotcha moment for NPrinting, sadly there's been way too many of these lately

Re: Calculation in master measure expression

ussy — Thu, 07 Apr 2022 10:29:08 GMT

Hello, hasn't this issue still been fixed by Qlik Team?

Re: Calculation in master measure expression

Frank_S — Thu, 07 Apr 2022 12:30:23 GMT

@ussy

Please check the following article.

https://community.qlik.com/t5/Knowledge/Qlik-Sense-charts-with-master-measures-used-in-Qlik-NPrinting/ta-p/1882332

Kind regards...