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!
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.