dynamic title in report based on trigger date

P_qlik — Fri, 09 Apr 2021 14:31:35 GMT

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

Re: dynamic title in report based on trigger date

Lech_Miszkiewicz — Sat, 10 Apr 2021 04:11:02 GMT

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.

dynamic reports title (help and video) https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Dynamic-report-naming.htm
variables in NPrinting: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Work-with-variables.htm

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):

Re: dynamic title in report based on trigger date

Ruggero_Piccoli — Mon, 12 Apr 2021 07:46:19 GMT

Hi,

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

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

topic dynamic title in report based on trigger date in Qlik NPrinting

dynamic title in report based on trigger date

Re: dynamic title in report based on trigger date

Re: dynamic title in report based on trigger date