

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
