topic Re: NPrinting Enable cycle based on a condition (Measure) in Qlik NPrinting

NPrinting Enable cycle based on a condition (Measure)

AjjuSid — Fri, 15 Nov 2024 22:13:33 GMT

Hi Experts,

Currently using NPrinting Apr 2020 V, I am looking for a solution for below scenario.

I am using enable cycle to generate the report for a list of managers (300) , while doing so I only want to generate the reports for managers who's sales (measure) exist or >1 .

This is to reduce the time taken to run the publish task.

I tried implementing the Filter - Evaluate value option but that didn't work for me as it is still producing same number of reports, it might be I may have not implemented in correct way.

Do we need to control this from the Qlik base App or NPrinting.

Can the experts please let me know how can we achieve this

@Lech_Miszkiewicz

Thanks a lot for your help.

Regards.

Re: NPrinting Enable cycle based on a condition (Measure)

Lech_Miszkiewicz — Mon, 25 Apr 2022 05:25:28 GMT

Hi,

You were going in right direction with the filter but... you have chosen wrong option. Instead of evaluate value which purpose is completely different you should use advanced search filter. the filter would be:

Field - Manager
Advanced Search:
- Formula: =sum(Sales)>1

I wrote about this in my blog: https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

cheers

Lech

Re: NPrinting Enable cycle based on a condition (Measure)

AjjuSid — Mon, 25 Apr 2022 13:59:00 GMT

That worked!! I should have gone through the documentation for better understanding of various options.

Thanks for you reply.

Re: NPrinting Enable cycle based on a condition (Measure)

Lech_Miszkiewicz — Mon, 25 Apr 2022 14:09:11 GMT

Hi @AjjuSid

Absolutely - going through documentation should be your first step before even starting development, so I am glad you recognise the need to study the manual and at the same time I am glad that this worked for you

cheers