topic Re: NPRINTING - Sort page excel from field in Qlik NPrinting

NPRINTING - Sort page excel from field

steeramp — Wed, 18 Oct 2023 10:20:54 GMT

Hi to all,

How can I make sure that the pages produced by the report are in order of month ( January - December) ?

In my case using the field "Période_MoisAnnée_Décalée"

Re: NPRINTING - Sort page excel from field

Lech_Miszkiewicz — Wed, 18 Oct 2023 11:20:55 GMT

Hi,

this topic was already discussed: https://community.qlik.com/t5/Qlik-NPrinting/how-to-specify-a-sort-order-for-pages-in-excel-report/td-p/1699837

Solution is to use Dual() field for page

cheers

Lech

Re: NPRINTING - Sort page excel from field

Frank_S — Wed, 18 Oct 2023 16:10:55 GMT

Here is a similar solution...

https://community.qlik.com/t5/Qlik-NPrinting/Sorting-levels-in-NPrinting/m-p/1768367/highlight/true#M30737

Re: NPRINTING - Sort page excel from field

Lech_Miszkiewicz — Wed, 18 Oct 2023 21:46:00 GMT

@steeramp To clarify - @Frank_S solution will work with levels but will not work with Pages where tables cannot be used!

Re: NPRINTING - Sort page excel from field

steeramp — Thu, 19 Oct 2023 06:47:11 GMT

Thanks @Frank_S but I think it is not possible to do Template Editor on an Excel Report.

Re: NPRINTING - Sort page excel from field

steeramp — Thu, 19 Oct 2023 06:54:15 GMT

Hi @Lech_Miszkiewicz ,

I did not understand at what level I need to add the new DUAL field. This is my report today:

Re: NPRINTING - Sort page excel from field

andregas — Thu, 19 Oct 2023 07:33:28 GMT

Hello @steeramp ,

Actually you are using the month as a level, that isn't a cycle page.

As metioned by other users, the order must be done on qlik connection in the load script. You must add a dual value to your month text field; dual assigns a number value to a corresponding text value of the field, so you can order by number a text field.

Regards

Re: NPRINTING - Sort page excel from field

Lech_Miszkiewicz — Thu, 19 Oct 2023 09:14:01 GMT

Hi @steeramp

In your description you are saying: "How can I make sure that the pages produced by the report are in order of month ( January - December) ?"

Pages in NPrinting excel template are those objects at the very top left side of NPrinting designer and they create individual sheets for each value of the field. Based on your description I assumed that is what you referred to hence I suggested creating Dual() field in Qlik Sense load script and use that in the Page. Looking closely on your template picture you are actually using "Levels" which I have missed as the "Level" label was not in english therefore follow @Franks suggestion.

Now If you are talking about sorting values in level please use @Frank_S suggestion where you can first create straight table object in Qlik Sense/QlikView and sort values in the order you want directly in Qlik. Once you do that you need to regenerate metadata and bring the new table object as level and use it instead of your current field. Make sure in your table field names dont have "=" sign in front of them as then they are not treated as fields but as calculated dimensions and you will not be able to use them as level. I saw on your template screenshot that you have many dimension fields starting with "=" sign which for those very reason is not really good practice.

cheers

Re: NPRINTING - Sort page excel from field

Lech_Miszkiewicz — Thu, 19 Oct 2023 09:15:19 GMT

Hi @steeramp

not sure what you mean that "it is not possible to do Template Editor on an Excel Report."?

It is definitely possible.

cheers

Re: NPRINTING - Sort page excel from field

steeramp — Thu, 19 Oct 2023 09:33:45 GMT

Great ! It was enough to transform the field to DUAL and everything worked , Thank you @Lech_Miszkiewicz @Frank_S @andregas