topic NPrinting Dynamically sort Excel Data Table Report in Qlik NPrinting

NPrinting Dynamically sort Excel Data Table Report

djbloiss — Thu, 25 Jan 2018 19:54:34 GMT

I am creating an Nprinting Report that I want sorted by its <Margin Equity> column. I added the columns in manually instead of simply adding the object ID. Then I created it as a data table with headers. Finally I sorted the last column. However, when the report goes out it is not sorted by the last column. Is there a way to do this, without creating it as an xlsm file and have a macro do it?

Btw, I don't know if this affects the ability but I do have it broken up on pages. I am using Nprinting version 16.

Re: NPrinting Dynamically sort Excel Data Table Report

Daniel_Jenkins — Thu, 25 Jan 2018 22:07:45 GMT

Hi Daniel,

You will need to do the sorting in the source document (QlikView qvw file).

HTH - Daniel.

Re: NPrinting Dynamically sort Excel Data Table Report

djbloiss — Fri, 26 Jan 2018 16:42:57 GMT

Thank you, I believed that was the case but I wasn't sure.