topic Re: NPrinting 17 - hide repeating values in Qlik NPrinting

NPrinting 17 - hide repeating values

kdmarkee — Tue, 11 Sep 2018 20:04:29 GMT

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.

Re: NPrinting 17 - hide repeating values

Ruggero_Piccoli — Wed, 12 Sep 2018 09:03:34 GMT

Hi,

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

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.

Re: NPrinting 17 - hide repeating values

Lech_Miszkiewicz — Wed, 12 Sep 2018 10:02:25 GMT

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

Re: NPrinting 17 - hide repeating values

kdmarkee — Wed, 12 Sep 2018 20:11:49 GMT

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?

Re: NPrinting 17 - hide repeating values

Ruggero_Piccoli — Thu, 13 Sep 2018 06:53:19 GMT

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

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

Re: NPrinting 17 - hide repeating values

kdmarkee — Thu, 13 Sep 2018 14:00:07 GMT

Thanks.