Sorting Levels in Pixel Perfect

[ryk_budzynski]

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

[Lech_Miszkiewicz · Accepted solution]

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

[ryk_budzynski]

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.

[Lech_Miszkiewicz]

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...

[ryk_budzynski]

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

[mstoler]

Hello,

This is brillant!

Thank You,

Michael

[Ruggero_Piccoli]

Hi,

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

Best Regards,

Ruggero