2 Replies Latest reply: Feb 9, 2018 10:50 AM by Michael Reagan RSS

    Possible to use a formula for an Excel tab name (NPrinting)?

    Michael Reagan

      Morning -

       

      Is it possible to use a formula or variable for a tab name for an Excel sheet with NPrinting? I'm trying to base the name based on the day the report is run:

       

      =If(Only({1<FullDate = {'$(=Today())'}>}Cal.DayNameAbbr) = 'Mon','Last Week', 'Week to Date')

       

      I've tried it as both a formula and a variable using <tab>  but without luck.

       

      I'm using NPrinting 16.6.

       

      Thanks!

       

      mike

        • Re: Possible to use a formula for an Excel tab name (NPrinting)?
          Ruggero Piccoli

          Hi,

           

          No, you cannot use Formulas or Variables in Excel report tabs.

           

          Qlik NPrinting 16.6 supports VBA macros (in the meaning that the VBA source code is copied from the template to all the generated reports) so you could drag and drop a Formula or a Variable in a hidden worksheet, write a macro that copy the value in the tab and trigger that macro on file opening.

          I have not tested this solution, so I'm not 100% sure that it works.

           

          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.