Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

mikecrengland
Contributor III

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

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

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

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

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
2 Replies
Employee
Employee

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

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
mikecrengland
Contributor III

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

Thanks, Ruggero!

Community Browser