4 Replies Latest reply: Nov 17, 2017 3:00 PM by Pritam Deb RSS

    NPritning - PPT - Legend Renaming

    Pritam Deb

       

      Hi All,

       

      Request to help to solve issue regarding NPrinting reports.

       

      We have following straight table in Qlikview:

       

      date

      Test1 A

      Test2 A

      Test1 B

      Test2 B

      10/1/2017

      100

      200

      400

      200

      10/2/2017

      200

      400

      100

      200

       

       

       

      We are creating PPT (Line Chart) using above table through  NPrinting.

       

      Let us say if we are referencing above table for creating two different slides in PPT

       

      In first graph date and Test1 A, Test2 A

       

      And in the second graph date and Test1 B, Test2 B

       

      The legend in the graph are displayed according to the expression name used in Qlikview (ie Test1 A, Test2 B etc)

       

      But we want the legend to be displayed as Test1, Test2 for both the slides

       

      We have tried changing the description name in NPrinting but it did not work.

       

      Waiting for reply. Thank You in advance!

       

        • Re: NPritning - PPT - Legend Renaming
          Lech Miszkiewicz

          Hi,

           

          I achieved the same by changing the series labels in XLS char supporting file when creating NPrinting Template.

           

          See all screenshots for details andattached test ppt file:

          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.

           

           

          1.png

           

          2.png3.png4.png5.png6.png

           

           

           

           

           

           

           

           

          regards

          Lech

          • Re: NPritning - PPT - Legend Renaming
            Pritam Deb

            Hi Lech,

             

            Thank You for the reply!

             

            Even I am following the same approach still I not getting the desired output.

            Also, I tried with unchecking the 'Keep Source format' but that also did not helped.

            In the above query I have given example for only two set (ie Test1 A, Test2 A and Test1 B, Test2 B) but originally in the application we have six set(total 47 expression).

             

            Regards,

            Pritam Deb

              • Re: NPritning - PPT - Legend Renaming
                Lech Miszkiewicz

                I am not sure if it makes any difference but...

                • on my last 2 screenshots on top orange powerpoint ribbon you see a "disk" icon to "save"(right above Home, Insert" section i PowerPoint). I have used this to keep saving my PPT template each time i have changed label..

                This is just shot in darknes - i am not sure if it will help.

                 

                regards

                Lech

              • Re: NPritning - PPT - Legend Renaming
                Pritam Deb

                Hi Lech,

                 

                Thank You for replying.

                 

                I tried saving the PPT as well but it did not worked

                 

                Regards,

                Pritam Deb