6 Replies Latest reply: Jul 17, 2017 4:52 AM by Ruggero Piccoli RSS

    NPrinting - Text file and semicolon separated

    Stephanie Floberg

      I have a pivot table and a straight table in a QlikView application.

      They want NPrinting 16 to create a text file of the repors. I know that the Pixel Perfect report can create that.

      But they want the text file to have the table in this format:

       

      Artist;Album;Genre;Avg(Längd)

      Avril Lavigne;The Best Damn,,,;Rock;0,13...

      Avril Lavigne;Goodbye Lullaby;Rock;0,14...
      Beyoncé;Irreplaceable;Pop;0,57...

      And so on....

      Is that possible for NPrinting to create?

       

      Test.png

        • Re: NPrinting - Text file and semicolon separated
          Lech Miszkiewicz

          I would do simple thing by creating a measure in QlikView which will have your string in it like;

           

          instead of Avg(Lang) i would have

           

          Concat(distinct Artist) & CHR(59) & concat(distinct Album) & CHR(59) & concat(distinct Genre) & CHR(59) & Avg(Lang)

           

          This will create whole string in one measure column

           

          Then you can export this only one column as a CSV using PixelPerfect

           

          cheers

          Lech

          ---------------------------------------------

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

          • Re: NPrinting - Text file and semicolon separated
            Ruggero Piccoli

            Also a Qlik Entity Report can be exported as CSV. PixelPerfect gives you a super control of the content, for example you can export only some columns of the original QlikView object. A Qlik Entity Report exported in CSV is faster to be created if you want to export the whole original object.

            QlikView Entity Report to CSV.png

            • Re: NPrinting - Text file and semicolon separated
              Ruggero Piccoli

              Hi Lech and Stephanie,

               

              If you want a semicolon as separator in Qlik NPrinting 16.* you must select skv as output format :-)

               

              Semicolon separated skv.png

               

               

               

              Best Regards,

              Ruggero

              ---------------------------------------------

              When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.