topic Re: NPrinting Conditions per User Filter in Qlik NPrinting

NPrinting Conditions per User Filter

HeinriG — Mon, 27 Apr 2020 14:37:40 GMT

Hi,

I have a NPrinting Publish task that has multiple users it needs to send the report to. Each user has a filter that must be applied (each one is different) to the report before it is sent. This part of my task works as intended.

I am having a problem filtering out reports that are empty after the user filter has been applied, meaning I only want to send reports to users that have data available after their filter is applied. I have a condition that checks the count of items in the chart (to see if there are any records) and I use this as a condition on the task report.

It seems that the condition is only checked once and is applied to all users and not evaluated per user as I would have thought (and what I interpreted from the help pages).

Does anyone have insight into why this is or how I could implement it otherwise? Any assistance would be much appreciated.

Kind regards, Heinri

Re: NPrinting Conditions per User Filter

Lech_Miszkiewicz — Mon, 27 Apr 2020 20:43:46 GMT

Hi,

when you say: " I have a condition that checks the count of items in the chart (to see if there are any records) and I use this as a condition on the task report. "

Can you screenshot place where you put your condition in?

Is it Task or is it Report? I am confused with "task report" wording you have used 🙂

Re: NPrinting Conditions per User Filter

HeinriG — Tue, 28 Apr 2020 05:48:15 GMT

Hi,

Thank you for your reply.

Here is a screenshot of the condition I use:

The variable "vMM_WorkOrderCodeCount" is simply defined as "Count([Work Order Code])"

It is a publish task that will send the report attached to an email to multiple users. In this publish task you can add a few reports (I only have this one). So when I say task report, I mean the report set up inside of the publish task has a condition linked to it and not the entire publish task.

Please let me know if you need any more information, I hope it is more clear now.

Kind regards, Heinri

Re: NPrinting Conditions per User Filter

Lech_Miszkiewicz — Tue, 28 Apr 2020 06:24:20 GMT

yep it makes more sense..

I was actualy asking for this kind of screenshot as I wanted to confirm that you are adding your condition at the place where marker no (2) is and NOT where marker no (3) is....

Re: NPrinting Conditions per User Filter

HeinriG — Tue, 28 Apr 2020 06:40:19 GMT

Hi,

Yes I see what you mean, I can confirm that I put the condition in where marker (2) is.

So would you also expect the condition to be evaluated after each user filter?

Kind regards, Heinri

Re: NPrinting Conditions per User Filter

Lech_Miszkiewicz — Tue, 28 Apr 2020 07:11:27 GMT

yep - thats all clear..

now down to your variable

The variable "vMM_WorkOrderCodeCount" is simply defined as "Count([Work Order Code])"... It should be defined as "=Count([Work Order Code])"

notice how I have added "=" sign which is required to allow for variable evaluation every time recipient filters are applied!

Try this and let us know how it goes.

Cheers!

Re: NPrinting Conditions per User Filter

HeinriG — Tue, 28 Apr 2020 07:56:55 GMT

Hi,

That seemed to do the trick! Thank you so much 🙂

I see now that it is a bit counter intuitive as the variable is now evaluated on the total amounts in Qlik Sense but in Nprinting it is evaluated per user filter (like a dimension would in Qlik Sense).

Very interesting, good to know!

Kind regards, Heinri

Re: NPrinting Conditions per User Filter

Lech_Miszkiewicz — Tue, 28 Apr 2020 08:14:03 GMT

no worries, I am glad I could help.

Just for the reference - official documentation regarding this:

https://help.qlik.com/en-US/nprinting/April2020/Content/NPrinting/Troubleshooting/Variables-dont-expand-before-calculating.htm

cheers!

Re: NPrinting Conditions per User Filter

Lech_Miszkiewicz — Tue, 28 Apr 2020 08:17:57 GMT

Well... yes and no...

so in your condition you are actually expecting to see total, but with all the filters applied as per task,report and user filters...

but the trick is more on how in Qlik you use object and $ sign to expand your variable, when in NPrinting whatever is in variable definition gets passed to NPrinting. The equal sign as you noticed causes expression to calculate and the actual value gets then returned.

Re: NPrinting Conditions per User Filter

HeinriG — Tue, 28 Apr 2020 08:30:10 GMT

Hi,

That's very true, that makes more sense 🙂

Thank you very much, NPrinting has been giving me some trouble lately but it seems to be coming together nicely 🙂

Kind regards, Heinri