excel template

[Manni_SM]

Hi @Lech_Miszkiewicz  @Ruggero_Piccoli  David_Friend 

i am working with excel template with pdf export and all the way report is working fine 

now customer is asking each sheet  i want last reload time and last download time in the footer 

i tried adding variables in page layout section header footer area 

<vreloadtime>   

{{vreloadtime}}

but nothing worked could you please help with any alternate solution.

am using Qlik sense NP feb2024 SR3 version 

[Lech_Miszkiewicz]

Hi @Manni_SM 

If you are referring to built-in excel headers/footers then those are not accepting any NPrinting tags and you will not be able to pass anything inside of them. 

My usual workaround is to put data in actual cells at the bottom or the top of the excel page (instead of utilizing built-in functionalities) and manage header and footer size to compensate for that. 

Regarding variables: You need to make sure your variables are expanded already in Qlik as documented here: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/Troubleshooting/Variables-dont-... 

cheers