5 Replies Latest reply: Apr 18, 2018 4:34 PM by Kris Markee RSS

    nPrinting 17 Excel output columns shifted

    Jonas Temin

      Hi,

       

      I have a table (Chart Straight Table) that I want to output in nPrinting.

       

      Problem is that the data columns gets shifted one column to the left.

       

      Has anyone experienced this problem in nPrinting 17 and Qlikview 12?

       

      Designer File:

      exampleN1.jpg

       

      Output File:

      exampleN2.jpg

       

      This worked just fine in previous version of nPrinting.

       

      Regards,

      Jonas

        • Re: nPrinting 17 Excel output columns shifted
          Andy Weir

          Looking at your example the Show header is set to hide and yet in your preview the custname is visible.  PErhaps your issue is related.  try not hiding the column header and see if your data returns.

          • Re: nPrinting 17 Excel output columns shifted
            Lech Miszkiewicz

            Hi

             

            I had the same situation. In my case it was related to hidden Dimensions or Measures in my source QlikView chart table.

             

            I ended up keeping all columns visible and everything started working as expected.

             

            Regards

            Lech

              • Re: nPrinting 17 Excel output columns shifted
                Jonas Temin

                This resolves this issue but I does mean that my Qlikview applikation needs to show all columns which is annoying.

                 

                Regards,

                Jonas

                  • Re: nPrinting 17 Excel output columns shifted
                    Lech Miszkiewicz

                    That is true,

                     

                    However as a best practice usually you have dedicated sheet (visible only for NPrinting user) with copies of objects you utilize in NPrinting reporting. This then is not visible for end users and it is not so much annoying anymore.

                     

                    My best practice though is to have dedicated for NPrinting reporting QlikView application. This is usually loaded only with fields and objects i need for reporting which then  works usually much faster and is easier to work with. This also is not affecting my application used by users. I know it is "double work" as you need to maintain 2 applications but from performance point of view is much better solution. I usually use binary load or full optimized QVD load to feed source to NPrinting QlikView App

                     

                    regards

                    Lech

                • Re: nPrinting 17 Excel output columns shifted
                  Kris Markee

                  I also experienced this (NP 17.5) but it was not due to hidden columns in my chart.  In my case, it turned out to be that when I changed the order of the columns in my chart, republished it to Access Point, reloaded the metadata in NP, and then updated my chart in the NP report designer, it didn't render the column order correctly.  I had to remove the chart from the Tables node in NP designer and re-add it, and also remove and re-add the columns to the excel layout.