Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
mwallman
Contributor II

How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Hello,

We have a NPrinting report using data from multiple QVWs. The users need the report to cycle through a Country field to produce 13 reports for 13 countries.

How is this possible for an NPrinting report made from multiple QVWs? We are using November 2017 version.

1 Solution

Accepted Solutions

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Hi,

Chanty's answer is not a cycle solution but effectively is the only way of producing in NPrinting required outcome.On top of what he said, you actually would need to create 7x13 country filters (each country for each connection) and apply all of them... It would be supper unefficient!

As NPrinting 17 does not support linked fields at the moment you cannot cycle through "linked field" value, therefore cycle functionality cannot be used.

Sorry!

cheers

Lech

---------------------------------------------

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

you must regenerate the cache in order to see the object in the template editor.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

8 Replies
Chanty4u
Esteemed Contributor III

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

create one app- create 7 connections -add the report which you want -create a country filter for each report ,

and schedule the same.

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Hi,

Chanty's answer is not a cycle solution but effectively is the only way of producing in NPrinting required outcome.On top of what he said, you actually would need to create 7x13 country filters (each country for each connection) and apply all of them... It would be supper unefficient!

As NPrinting 17 does not support linked fields at the moment you cannot cycle through "linked field" value, therefore cycle functionality cannot be used.

Sorry!

cheers

Lech

---------------------------------------------

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

you must regenerate the cache in order to see the object in the template editor.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Employee
Employee

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Hi,

Evaluate also to create a single .qvw only for reporting and connect it with Qlik NPrinting. After you will be able to use cycles because the source is unique.

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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.
andrewmo
Contributor

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Is there any solutions for this in the future? Having multiple QVWs to maintain is not very efficient.

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Hi Andrew,

In regards to Qlik's plans/roadmap for "linked fields" i am not sure.

Answering your question regarding maintaining multiple QVWs... i think long term you still need multiple QVW's to improve performance of NPrinting - see this --> QVW size limitations with NPrinting 17‌.

I am convinced that for NPrinting you will always need a dedicated app (as very often you have to build custom objects -with expressions serving only NPrinitng layers). This used to be easier with QlikView where you could simply hide a sheet or object, but in Qlik Sense yo udon't have this functionality so it would look odd if your app would contain charts, tables and objects which dont follow logic of the other sheets.

If you are dealing with small apps and you don't have to worry about performance putting everything into one app is also a possibility.

regardless i think it is worth splitting apps, and i admit it is additional effort, but long term will pay off with better performance.

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Employee
Employee

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

...and move to a server environment with good hardware resources.



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.
Partner
Partner

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Hi Ruggero,

We are using NPrinting Apr 2019 (we have Qlik Sense).
We need to cycle a report which is composed of variours graphs/KPIs taken from 2 different Connections.

We want to cycle the report using a unique field (lets say "Country") which actually exists in both Qlik Sense Dashboards.
(We have the field "Country" coming from Connection1 and the field "Country" coming from Connection2")
Of course the values of the fields named "Country" are the same.

Is there a solution to cycle our report apart from creating a unique QLik Sense App?
If you need more details,  do not hesitate to contact me

It will be a pleasure for me if you could let me know
Thanks
Chiara  

Re: How to Cycle an NPrinting report made from 7 different QVW connections based on one field?

Hi @ChiaraConforzi 

This is not supported yet and I dont know if it will be. There is no linked fields feature in Qlik NPrinting!

Workaround is to create merged Qlik Sense data model which will contain bot models you want to cycle through

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.