Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
padmashini_rama
Partner
Partner

Qlik NPrinting Scenario - PDF Report

Hi All,

Clarification and Suggestions required for the below Qlik NPrinting requirement.


Having two different data models in single QlikView application. Even though its independent data model, some of the filters and dimension columns names displayed are same in QlikView front end. With the same QlikView application we have a requirement to generate PDF report with both the data model fields and charts.

Example:

Having two fields namely Region1(from 1st data model) and Region2(from 2nd data model), in QlikView front end it is displayed as “Region” (commonly) in two different tabs/sheets.

In NPrinting, need to generate and distribute the PDF report by enabling cycle based on Region field with QlikView objects from both the tabs/sheets.

So the number of reports generated is 49 as we have 7 values listed in each Region columns, but the expected number of reports is only 7 as the values listed in each Region is one and the same.

Note: As number of reports generated is 49 with more than 2000+ pages, there comes a space issue and other report maintainability concerns.

So, request you to let me know if there is any similar scenario faced and any solutions to be tried from our end. Thanks

Regards,

Padma

4 Replies
Ruggero_Piccoli
Employee
Employee

Hi,

When you start a conversation please remember to always specif the version of Qlik NPrinting you are using; 16.* are very different than 17+.

Having two data models in the same .QVW is an unusual situation. In my opinion it would be better to merge them in a single model.

In any case:

- with 16.* you should try to use Linked Fields. They are designed to connect correspondent fields from different connections and I never tested them when connecting two different fields from the same .qvw (=the same connection). So try to create a Linked Field, insert the two Region fields and create a cycle by using the Linked Field and remove the single Region field.

- with 17+ at the moment (September 2018) Linked Fields are not supported so you can cycle only by an existing field. The only solution is to merge the two models in a single one in order to have a single field Region and use it to cycle.

If you have two fields and create a cycle only with one the data set will not be filtered by the second one.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.
padmashini_rama
Partner
Partner
Author

Thank you Ruggero for your response.

Yes, missed to mention the version, NPrinting version- 17+.


Based on the requirement and database tables availability team have come up with two different data models in single QVW app. Merging into single data model is in process now, meantime I would like to know if there is any other workaround to handle the scenario. Thanks.

Regards,

Padmashini

Ruggero_Piccoli
Employee
Employee

Not now but it will work when you finish to merge.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.
Lech_Miszkiewicz

For NPrinitng purpose (as best practice is to have separate application) i would link models on the "Region" field and cycle through it.

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.