Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III

How to merge two tables into single table in Nprinting pixel perfect report

Hi all,

I have two different qlik sense app. I have created two different qlik sense connection and I have added both qlik sense connection into single common report in NPrinting. So that I can pull data from both Qlik sense app during creation Nprinting report .

I'm able to pull all data like graphs and table from both Qlik sense app into single Nprinting report.

Now I have added one -one table from both Qlik Sense app into Qlik Sense  Pixel perfect Nprinting report.

Now I want to merge both Qlik Sense table into single table in pixel perfect report.

Table should be like this:-

1st row - 1st row from first table

2nd row- 1st row from second table

3rd row - 2nd row from first table

4th row- 2nd row from second table

means alternate  rows.

Is this possible to create table in such a way becase I need to create a comparative report based on both  Qlik Sense app data.

1 Solution

Accepted Solutions
Ruggero_Piccoli
Support

Hi,

Based on how PixelPerfect reports work it is not possible to merge two tables as you are asking. You can insert the first table and after the second by using two different levels.

We always suggest to create a Qlik Sense app specific for reporting. So you could create an app that loads data from both the two original apps, create the table as you need an import it into the report template.

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.

View solution in original post

4 Replies
bramkn
Partner - Specialist

I have bad experience with using 2 different connections for one report. Also couldn't get the filtering and cycle etc. to work. Best thing I would think would be to create a specific app for NPrinting with all the needed data. This has a few more bennefits as the reports won't get messed up if someone plays arround in the (dashboard) app.

vanand3535
Creator III
Author

But I have two different qlik sense app and there more 30 sheets in both app.

Sp merge both app and to use in Nprinting only way is to create two different connection for both app and then add under a common report then only we can pull both qlik sense app data.

Ruggero_Piccoli
Support

Hi,

Based on how PixelPerfect reports work it is not possible to merge two tables as you are asking. You can insert the first table and after the second by using two different levels.

We always suggest to create a Qlik Sense app specific for reporting. So you could create an app that loads data from both the two original apps, create the table as you need an import it into the report template.

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.
vanand3535
Creator III
Author

yes, you are right. Just now Tried. Output is like this:-

1st row:- 1st row from table1

2nd row:- full second table is comming

3rd row:- 2nd row from first table

4th row:- full second table is comming

like this.

I just added one table into label object then i added second table inside first level to make parent child relationship