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: 
kdmarkee
Specialist
Specialist

NPrinting 17 - hide repeating values

I am running QV 12 and NP April 2018.  I have a pixel perfect report where my straight chart is being used as a level and I want to show the following, where when there are multiple rows per patient, the patient name is only listed on the first row (see patients Sam and Sally).  Can this be achieved?  Thanks.

eliminate repeating value.PNG

1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

  1. Select the field with duplicated values you want to remove
  2. Set the "Process Duplicates Mode" to Merge or to Suppress

Delete Duplicated Values.png

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

5 Replies
Ruggero_Piccoli
Support
Support

Hi,

  1. Select the field with duplicated values you want to remove
  2. Set the "Process Duplicates Mode" to Merge or to Suppress

Delete Duplicated Values.png

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
Partner Ambassador/MVP
Partner Ambassador/MVP

love it, i was curious how to do this, but never chased it properly

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.
kdmarkee
Specialist
Specialist
Author

Thanks I'll try it.  So what is the difference between Suppress and Merge?  I've tried to find some of these properties in the NP Online Help but nothing comes up when I use the search feature.  Is there any documentation out there that exists that would describe all of the properties available in NP?

Ruggero_Piccoli
Support
Support

Hi,

Suppress will delete the value from the cells under the first

Merge will merge all the cells under the first into a single cell

So, if you export the PixelPerfect report in PDF there are not differences between the two option if what you will see.

To see the difference you need to export in Excel format, but I suggesto not to create a PixelPerfect template if you want a final report in Excel format.

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.
kdmarkee
Specialist
Specialist
Author

Thanks.