topic Re: Report field cycle in Qlik NPrinting

Report field cycle

ali_hijazi — Thu, 25 Jul 2024 12:11:15 GMT

Hello got an Nprinting report in which I'm cycling by 2 fields
field1 and field2
field1 is never null while field2 could be null for some records
the thing is that the report is not generated for field1 and field2 when field2 is null

is there something I can do so that the report is generated for field2 even if it is null

currently the name of the report is TimesToValidate_name_of_project_manager_name_of_project_follower
so if field2 is null (which is the project follower) then let the output be named TimesToValidate_name_of_project_manager_

kindly advise

Re: Report field cycle

Ruggero_Piccoli — Thu, 25 Jul 2024 12:42:39 GMT

Hi,

You could create a new field12 by concatenating field1 and field2 in the reload script and run the cycle by field12.

In the concatenation formula you can manage the string when field2 is null to have the correct name of the generated report. For example you will have field1value_field2value when field2 is not null and field1value when field2 is null.

Best Regards,

Ruggero

Re: Report field cycle

Frank_S — Fri, 26 Jul 2024 22:48:05 GMT

Further to Ruggero's point. Here is a concatenation example: