topic Re: Sorting In Nprinting. in Qlik NPrinting

Sorting In Nprinting.

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

I need to sort one column in ascending order which is available in detail band pixel perfect report. How to achieve that.

Re: Sorting In Nprinting.

Lech_Miszkiewicz — Wed, 15 Nov 2017 10:18:52 GMT

Sort your source (object used in Nprinting Level Node) in QlikView or QlikSense using custome sorting by expression.

that should be the easiest solution

regards

Lech

Re: Sorting In Nprinting.

Smeenakshi23 — Wed, 15 Nov 2017 10:24:10 GMT

In Qlikview i have sorted it, but then in Npritning it is not sorted ..

Re: Sorting In Nprinting.

Lech_Miszkiewicz — Wed, 15 Nov 2017 10:28:32 GMT

This is strange..

I am not sure now, if it is required to re-generate metadata after setting up new sorting order (I would have done it just in case)

I will test it tomorrow and will let you know.

regards

Lech

Re: Sorting In Nprinting.

Smeenakshi23 — Wed, 15 Nov 2017 10:29:00 GMT

Could you pelase let me know hot to sort it in Nprinting level as u mentioned in the above comment

Re: Sorting In Nprinting.

Smeenakshi23 — Wed, 15 Nov 2017 10:29:45 GMT

Sure Thank you

Re: Sorting In Nprinting.

Smeenakshi23 — Wed, 15 Nov 2017 10:31:03 GMT

The sorting order is different in Nprinting Pixel Perfect report when compared to Qlikview Report

Re: Sorting In Nprinting.

Smeenakshi23 — Thu, 16 Nov 2017 04:41:56 GMT

Got it sorted.

In Qlikview the column were sorted in Descending order. I noted only the table box and failed to note the list box.

Now it woks properly.

Re: Sorting In Nprinting.

Lech_Miszkiewicz — Thu, 16 Nov 2017 04:49:27 GMT

Hi I am glad it works for you.

If sorting listbox helped you achieve what you wanted, that means that instead of table you have used listbox in your Levels in NPrinting, right?

Re: Sorting In Nprinting.

rajeshwar1 — Tue, 14 Mar 2023 07:27:52 GMT

Hi , I want to sort the Column in Excel Template editor how can i achieve it

Re: Sorting In Nprinting.

Lech_Miszkiewicz — Tue, 14 Mar 2023 08:02:16 GMT

Hi @rajeshwar1

Why do you think you can do it at all? The nature of excel is that it provides sorting to existing values. When You use NPrinting you dont have those values populated in template hence technically as excel limitation you cannot do it and solution for that is to sort data in your Qlik app accordingly.

simple as that!