1 Reply Latest reply: Dec 12, 2017 7:05 AM by Darrell Tobin RSS

    sort by expression

    Amichai Marbel

      hey experts,

       

      I use NP September 17 and QS 3.2

       

      In QS I create table that sorting by expression

      (with "export data" its OK),

      but when I create report with that table in NP, the sorting is change from the expression to alphabet.

      I check it also with image and I get the same problem.

        

       

      its look like the NP ignore the expression..

       

      thanks.

        • Re: sort by expression
          Darrell Tobin

          Hi Amichia,

           

          You are correct I have seen this too.

          Best work around would be to create an extra column in your Qlik table similar to your expression and sort your table on this alphabetically.

          Your table in NPrinting should now be in correct order, if not then add this column to the table in NPrinting so it will sort this way.  Then hide the new column in your NPrint report.

           

          If helpful or correct please mark as such.

           

          Thanks

           

          Darrell