Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Nprinting Pixelperfect dimension level custom dimension order

In NPrinting pixelperfect I am trying to have separate tables with the data by the canal dimension.

sdfgfdsg.PNG

The thing is that I want to change the order of the values of this dimension but NPrinting doesn't allow it as displays the default alphabetical order when using the dimension

 

asfd.PNG

Obviously the source table has the correct sort order.

 

Any help?

 

Labels (2)
5 Replies
Highlighted
Support
Support

Re: Nprinting Pixelperfect dimension level custom dimension order

Hi @lanlizgu 

If I understand your requirement correctly, go to 1 hour 28 minutes 58 seconds in the following video to watch how to use a group head and group footer to achieve your objective. It is the NP 16 designer by the design principle is identical in NPrinting 17+ platform.

https://www.youtube.com/watch?v=YiTy_cPqRSk

Hope this helps...fs

 

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Highlighted
Creator III
Creator III

Re: Nprinting Pixelperfect dimension level custom dimension order

Hi Frank,

 

Thank you for your answer, However the video you are refering to explains how to use a group head and group footer as you are mentioning, but doesn't mention the objective of the post.

The objective of the post, apart from grouping headers to have separate tables by dimension that is already done, is these level dimensions to appear ordered in a custom way (A, E, G, C) and not alphabeticlaly as it is being displayed

 

 

Highlighted
Support
Support

Re: Nprinting Pixelperfect dimension level custom dimension order

In my report example, I updated the QVW with a specific sort order (this should also apply similarly to Qlik Sense if needed). then reloaded my NPrinting connection and the result was A>Z sort order in my report output.

It's not ideal since this solution involves updating the source QVW or QVF but it does work. I also attached a copy of the output with the expected sort order. 

sort order.PNG

 

 

 

 

 

 

 

template editor.PNG

output sorted a to z.PNG

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Highlighted
Creator III
Creator III

Re: Nprinting Pixelperfect dimension level custom dimension order

Hi Frank, Thank yoy but as you can see, you are displaying the categories alphabetically, when I want them to be displayed in a custom way.

Highlighted
Creator III
Creator III

Re: Nprinting Pixelperfect dimension level custom dimension order

As I have 4 values in the dimension and I want one of them (is not the last one alphabetically) to be the last one, what I did was to duplicate the tables by 2 and generate two dimensions more (one with the first three values and other one with the last value), so each table has it dimension and I am able to show the dimension in the custom order.