topic Re: Sorting Levels in Pixel Perfect in Qlik NPrinting

Sorting Levels in Pixel Perfect

ryk_budzynski — Fri, 30 Oct 2020 04:42:51 GMT

Hi All I have created a level 'State' in an NPrinting Pixel Perfect report to create a report section per state. The problem is I want to be able to sort the sections by another field (State Sort Order) but can't see where to do this. It is defaulting to an alphabetical sort order. I tried creating State as a Dual but then found there is an issue where only the numeric component is displayed. Any ideas? Thanks Ryk

Re: Sorting Levels in Pixel Perfect

Lech_Miszkiewicz — Sun, 01 Nov 2020 21:48:37 GMT

Hi, Put a State field into a straight table, apply sorting on that table to your liking and use a table as a level in Pixel Perfect template. Make sure you refresh metadata beforehand. cheers

Re: Sorting Levels in Pixel Perfect

ryk_budzynski — Sun, 01 Nov 2020 23:07:31 GMT

Hi Lech - how do you then bind the state in the detail reports within the table level, to the state column of the table? When I had the level just as a field, the selection on state was implicit and so the detail reports were filtered accordingly.

Thanks, Ryk.

Re: Sorting Levels in Pixel Perfect

Lech_Miszkiewicz — Sun, 01 Nov 2020 23:40:31 GMT

Hi,

I am not sure what do you mean by: "When I had the level just as a field, the selection on state was implicit and so the detail reports were filtered accordingly" - The same is going to happen when you create level based on that straight table in QlikView or Qlik Sense with State as dimension...

Just like in documentation: https://help.qlik.com/en-US/nprinting/September2020/Content/NPrinting/PixelPerfectReports/Add-Totals-Subtotals.htm#anchor-5

Re: Sorting Levels in Pixel Perfect

ryk_budzynski — Sun, 01 Nov 2020 23:54:26 GMT

Hi Lech

My mistake - I'd forgotten to re-add the report tables as levels under the new table level - all working now. Many thanks for your help.

Ryk

Re: Sorting Levels in Pixel Perfect

mstoler — Wed, 05 Oct 2022 17:39:57 GMT

Hello,

This is brillant!

Thank You,

Michael

Re: Sorting Levels in Pixel Perfect

Ruggero_Piccoli — Thu, 06 Oct 2022 07:04:46 GMT

Hi,

Here there is a step-by-step tutorial https://community.qlik.com/t5/Official-Support-Articles/Custom-sorting-in-Qlik-NPrinting-PixelPerfect-tables/ta-p/1486553

Best Regards,

Ruggero