Only produce report that are not empty when using cycle

[Qiyanlu66]

Hello all,

When I create report when using cycle, there are a lot of report has no data in it. Is there anyway I can not produce them?

I have tried to use Condition, but still can not filter out the empty report.

Thank you .

[Qiyanlu66]

To be clarify, when I produce the reports and cycle by the Company_Name, there should be many company has not data on it. So my question is can I not produce these blank reports.

[mr_barriesmith]

I have used Conditions in Qlik NPrinting 18 to do this.  I however did not have a cycle.

[Qiyanlu66]

Yeah, I am not sure if the result of a cycle of report can be use a Condition or not?

[Lech_Miszkiewicz]

hi all,

...on the other hand i am sure how it works...

At the moment you cannot use condition to control behaviour you are experiencing as condition does not work on each cycle value!

With the latest version of NPrinitng the only thing you can do is to use Qlik script to flag customers you want to generate reports for and use this flag as a filter in NPrinting

With the next version of NPrinting (June 2019) you will be able to create and apply advanced search filter on customer filed (for example: Customer: sum(Sales)>0) - such filter will remove all customers who don't have sales. With advanced search filters you will be able to create a condition to suit your needs.

cheers

Lech 

[Ruggero_Piccoli]

Hi,

Maybe you are applying conditions in the wrong place. Refer to https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ReportsDevelopment/Conditions.htm#...

I think you have to apply the condition to the publish task report so also the user filters will be evaluated before to calculate the condition.

Best Regards,

Ruggero

[Lech_Miszkiewicz]

Hi @Ruggero_Piccoli 

Are you sure? I think I have never managed to create a condition which will work together with Cycle option on Report  nad would evaluate on each cycle value.

just testing it now with NP April 2019 and cannot get it working...