8 Replies Latest reply: Aug 4, 2017 5:52 AM by Andrea Ghirardello RSS

    Nprinting 16: Remove Blank Pages (Excel)

    Cassandra Baqir

      I am still stuck on this requirement and need some help...no luck so far.

       

      My NSQ creates an Excel doc with paging by REQUEST_REGION. Each tab contains 2 charts, an image and some random text.

       

      My requirement is to remove the tab if CH229 is empty.I've played with conditional formatting and variables but I cannot get it to work.

       

      I've been working on this for 2 weeks and cannot make it work.

       

      Here's an example of a tab that I want removed (Arizona) because CH229 is blank:

      8-2-2017 8-38-30 AM.jpg

      8-2-2017 8-36-55 AM.jpg

      TIA!

        • Re: Nprinting 16: Remove Blank Pages (Excel)
          Andrea Ghirardello

          Try with this:

          - create a straight table using the dimension you need and the measure that determines which charts become empty (in your case what is causing CH229 to be emty).

          - enable the "suppress zero values" for  that measur. THIS STEP IS IMPORTANT otherwise you won't see the straight in the list of available entities for page

          - add whatever you need in each sheet

          - click on preview.

          - you shouldn't see any sheet for values that has the chart empty (in the attached example Germany)

           

           

           

          see attached samples.

          In order to use them, please download and respect the folder structure:

          - "\NPrintingFiles" for the nsq project

          - "\Templates" for the template

          - "\QlikViewDocuments"  for the doc

           

          Hope this helps.

           

          Andrea

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

          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 16: Remove Blank Pages (Excel)
              Cassandra Baqir

              - enable the "suppress zero values" for  that measur. THIS STEP IS IMPORTANT otherwise you won't see the straight in the list of available entities for page

               

              You mean for the Expression via the Presentation tab, right? I have this but it isn't showing up.

              8-2-2017 10-25-28 AM.jpg

               

              I also have it on the Dimension itself:

              8-2-2017 10-26-52 AM.jpg

              • Re: Nprinting 16: Remove Blank Pages (Excel)
                Cassandra Baqir

                My straight table show's the same dimension more than once - because of the other fields included. It's throwing off my paging because it's creating multiples. What am I missing?

                 

                8-2-2017 2-49-45 PM.jpg

                8-2-2017 2-50-25 PM.jpg

                  • Re: Nprinting 16: Remove Blank Pages (Excel)
                    Lech Miszkiewicz

                    My straight table show's the same dimension more than once - because of the other fields included. It's throwing off my paging because it's creating multiples. What am I missing?

                     

                    That is why you have to create another straight table which will exclude "those other fields" and use it as a paging entinty in NPrinting template.

                     

                    regards

                    Lech

                    • Re: Nprinting 16: Remove Blank Pages (Excel)
                      Andrea Ghirardello

                      Hi,

                      Let me explain better...

                      The Page feature allows you to use a field (only one) for cycling and creating a different sheet for each value of that field.

                       

                      If you create a Straight table that contains at the very end only one field, even if calculated and even if in reality the table contains more columns but all but one are hidden, then you will be able to use the table for the page.

                       

                      So finally, the final (visible) table need to show only one field in order to be visible in the Page field list.

                      Last thing.. the fact that you see the same value more than one time, is caused by the presence of multiple dimensions in the table, even if hidden.

                      I've no knowledge on your data structure but I think you should remove unuseful fields with regards to page.

                       

                      Hope this helps

                      Andrea