topic Re: NPrinting Pixel Perfect Table Top Others in Qlik NPrinting

NPrinting Pixel Perfect Table Top Others

lanlizgu — Mon, 29 Oct 2018 08:07:14 GMT

Hi,

When I create a table in Qlik Sense for the TOP 10 values including others

The line of others is not present in the pixel perfect report for this table. Do you know how can the others line be included in NPrinting?

Re: NPrinting Pixel Perfect Table Top Others

Ruggero_Piccoli — Tue, 30 Oct 2018 13:46:13 GMT

Hi,

Sorry for my delay. I'm able to reproduce and I have not a workaround at the moment.

I suggest you to open a support ticket and include the link to this conversation. If confirmed it will be moved to the bug list.

If I will find a workaround I'll post it here.

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 Pixel Perfect Table Top Others

lanlizgu — Tue, 30 Oct 2018 14:58:47 GMT

Thank you so much Ruggero.

I will proceed as you mention and update also the thread in case of having news.

Re: NPrinting Pixel Perfect Table Top Others

lanlizgu — Wed, 07 Nov 2018 09:22:41 GMT

Hi Ruggero,

At the end I was able to find a workaround that works.

It is basically to add the line of the others. Therefore I created an expression with all the data and substracted the data of the 10 top values.

It is something like this:

sum(VALUE)

sum({< FIELD= {"=Rank(SUM(VALUE),6)<=10"}>}VALUE)

Thank you.

Best regards.

Re: NPrinting Pixel Perfect Table Top Others

Ruggero_Piccoli — Wed, 07 Nov 2018 09:32:56 GMT

Hi,

Thanks for sharing the solution. It will be useful to other people.

Please keep the support ticket open and mention the workaround. I would that developers analyze the issue.

Best Regards,

Ruggero

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