Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
P_qlik
Partner - Contributor III
Partner - Contributor III
‎2021-04-09 10:31 AM

dynamic title in report based on trigger date

Hi,

I need to have a dynamic report title based on the date on which there will be the trigger ( in my case every monday), so I need to insert the extraction date both in the top of the excel sheet and in the title of the file excel, how can I do?

Thank you

Labels (2)
Labels
795 Views
0 Likes
1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2021-04-10 12:11 AM

Hi, Since you are the Qlik partner you should be very familiar with help site https://help.qlik.com. On this side there is everything you need to know about this subject. Please study it or google it before posting question which is very well documented.

In short: for whatever dynamic title in this case you can use Qlik Sense variable (For date it can be simply variable like "=Text(Date(Today(),'DD MM YYYY'))". Note that date format you can change according to your needs. Make sure you take into account characters which are prohibitted in file names like ":" or "/"...

As an alternative you can create such variable in load script and set it value there too.

Make sure you study it carefully as there is a lot to learn, also make sure you understand why variable may not expand properly (it is also in help)!

Similar topics on community (it may slightly differ as some examples cover v16 of NPrinitng which is different):

 

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

767 Views
2 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2021-04-10 12:11 AM

Hi, Since you are the Qlik partner you should be very familiar with help site https://help.qlik.com. On this side there is everything you need to know about this subject. Please study it or google it before posting question which is very well documented.

In short: for whatever dynamic title in this case you can use Qlik Sense variable (For date it can be simply variable like "=Text(Date(Today(),'DD MM YYYY'))". Note that date format you can change according to your needs. Make sure you take into account characters which are prohibitted in file names like ":" or "/"...

As an alternative you can create such variable in load script and set it value there too.

Make sure you study it carefully as there is a lot to learn, also make sure you understand why variable may not expand properly (it is also in help)!

Similar topics on community (it may slightly differ as some examples cover v16 of NPrinitng which is different):

 

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
768 Views
Ruggero_Piccoli
Support
Support
‎2021-04-12 03:46 AM

Hi,

You could also add the Qlik Sense formula as a Qlik NPrinting formula:

Ruggero_Piccoli_0-1618213510269.png

In case, for example, you cannot change the Qlik Sense app. More details in https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Formulas.htm.

Best Regards,

Ruggero

 



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.
754 Views