7 Replies Latest reply: Mar 8, 2018 4:18 AM by Ruggero Piccoli RSS

    Headers in report still show

    Johan Kruize

      In nprinting I created a report containing a table from Qlik.

      This report contains two levels.

       

      Allthough I set all headers to "hide" they still show and the total table too, they still show up.

       

      What do I have to change ?

        • Re: Headers in report still show
          Ruggero Piccoli

          Hi,

           

          Please specify the version of Qlik NPrinting you are using.

          Post a screenshot of the template so we can see the structure.

           

           

          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.

          • Re: Headers in report still show
            Johan Kruize

            We are using 17.6.0000.

            EDIT: I added a "delete-row"tag in the cell below <Rubriek_Grootboek_1> and now the headers do not show.

            Is this the right way to remove the headers? What is the purpose of the "hide-headers" property then ?

              • Re: Headers in report still show
                Ruggero Piccoli

                Hi,

                 

                Delere row is used to delete the row where you place it and it doesn't matter with column headers.

                To hide header you correctly set the Show headers attribute.

                Headers.png

                Please note that in the attached template the headers are write by the red highlighted cells and not comes from the Qlik object. In this template headers will appear also if you set Show headers to hide.

                 

                 

                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.

                  • Re: Headers in report still show
                    Johan Kruize

                    The read highlighted cells appear when I draw a field from the table into the template.

                    So every time when I draw a field into the template two cells are filled (the header-  and the value-tag). So what will be hidden by selecting the "hide header" property ?

                      • Re: Headers in report still show
                        Ruggero Piccoli

                        Delete the row of the template with the headers as you do in a normal Excel file and keep the Show headers option to hide.

                         

                        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.

                        • Re: Headers in report still show
                          Matus Kelemen

                          It is a bit contraintuitive that drag&drop still brings the headers even after you select hide headers. So you have to delete them. The difference is that they are added when report is generated.


                          This is from NP17 help but I think it behaves the same as in NP16.

                          https://help.qlik.com/en-US/nprinting/September2017/Content/ExcelReports/FullExcelTableCompatibilityNPrintingRelease/Ful…


                          Hide: Qlik NPrinting will not add headers. You can type them, or obtain dynamic headers using QlikView variables and Excel formulas.


                          Show in tag cell: column headers will be inserted in the tag cells and data will start in the row below. Formulas and variables in original QlikView headers will not be replaced.


                          Show above tag cell: column headers will be inserted in the row above tag cells. Data will start on the row with the tags. Use this option when column headers in the original QlikView documents use variables or formulas and you want them to be reported in the table.

                           

                          BR,

                           

                            Matus

                            • Re: Headers in report still show
                              Ruggero Piccoli

                              Hi,

                               

                              I'll open a help page improvement.

                              Note that the Show headers option is available for the table and for the columns.

                              If you drag and drop the table tag the headers will not be added as cell text.

                              If you drag and drop some columns the headers will be added as text cells. The Show headers option continue to works so, for example, you can delete the text headers an use the ones added by Qlik NPrinting.

                               

                              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.