Solved: Report field cycle - Qlik Community

ali_hijazi · ‎2024-07-25

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

I can walk on water when it freezes

Ruggero_Piccoli · ‎2024-07-25

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Ruggero_Piccoli · ‎2024-07-25

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Frank_S · ‎2024-07-26

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

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report field cycle

Qlik NPrinting February 2024 IR

Qlik Sense

Report field cycle

Qlik NPrinting February 2024 IR

Qlik Sense

Related Topics