topic Re: Sort Order in Cycle Rapports in Qlik NPrinting

Sort Order in Cycle Rapports

johnan — Wed, 25 Sep 2019 18:40:54 GMT

Hi, i have a XLS there i'm getting my orders. I just want N-Print to create my reports as they are in my XLS in that order.

Is it possible?

Cheers!

Re: Sort Order in Cycle Rapports

pradosh_thakur — Thu, 31 Jan 2019 10:44:14 GMT

Can you please mention what you want clearly? It's unclear.

Re: Sort Order in Cycle Rapports

johnan — Thu, 31 Jan 2019 10:51:42 GMT

Okay.

I have a QlikView with lot of data and i have created a Wordtemplate in N-Print.

It's based on ordernumbers and getting data from QlikView to N-Print to my wordreport.

N-Print is cycle reports if there is more than one order. I getting my ordernumbers from a XLS.

Like this (XLS):

Varu	Ordernummer	pall
237	472393	18
240	740873	17
227	22700737	20

Then i get the reports in my mail with the reports attached. But i want them to be in that order as the XLS is.

MAIL:

Br John

Re: Sort Order in Cycle Rapports

pradosh_thakur — Thu, 31 Jan 2019 11:07:24 GMT

Well. It is printing eveerything in the numeric order.

Try this which may work, just a work around which i can think of.
create a column in the xls which will have unique value for all the order number and in ascending order . Use that field in your cycle as well. I would try this with a few records first.

Varu Ordernummer pall sort_order
237 472393 18 1
240 740873 17 2
227 22700737 20 3

Re: Sort Order in Cycle Rapports

johnan — Thu, 31 Jan 2019 12:39:47 GMT

Working perfect!
Thanx Mate!
Br John

Re: Sort Order in Cycle Rapports

pradosh_thakur — Thu, 31 Jan 2019 13:00:48 GMT

Great!!

Re: Sort Order in Cycle Rapports

Lech_Miszkiewicz — Thu, 31 Jan 2019 23:22:58 GMT

I would simply use "Load Order" sorting on the field you are cycling through in NPrinitng. Simple solution and does not require any additional fields.

regards

Lech

Re: Sort Order in Cycle Rapports

johnan — Fri, 01 Feb 2019 07:43:20 GMT

Hi Lech, can you tell me more?
The first load I made read directly from XLS and I thought it would cycle in that order. But not
Br John

Re: Sort Order in Cycle Rapports

Lech_Miszkiewicz — Fri, 01 Feb 2019 09:26:13 GMT

Are you using QlikView or Qlik Sense with it?

Re: Sort Order in Cycle Rapports

johnan — Fri, 01 Feb 2019 09:27:58 GMT

QlikView
Br
John

Re: Sort Order in Cycle Rapports

Lech_Miszkiewicz — Fri, 01 Feb 2019 09:37:51 GMT

So in QlikView Document you need to go to:

Settings --> Document Settings
- Go to Sort tab and choose field you want to sort on
- Select/Mark "Load Order" and unselect all other sorting options

This should set default sorting of this field based on load order

regards

Lech

Re: Sort Order in Cycle Rapports

johnan — Fri, 01 Feb 2019 09:43:02 GMT

Ahh, i will test that!
Thanx