NPrinting Excel Table Dynamic Column Headers

[Pomna]

Hello experts I need to make my NPrinting  excel report columns dynamic. I want the column headings to show current quarter. Am importing the chart as a table and not as image as I want the end user to be able to interact with the report. These are my set expressions below

Sum({<Quarter={"$(vQuarter)"}>} Goals) should read Q4 Goals

Count({$<Goals={">0"}, Year={'2020'}, Quarter={"$(vQuarter)"}>}[Applicant ID]) / Sum({$<[Applicant Submit Date]=,Quarter={"$(vQuarter)"}>} [Goals]) should read Q4 Applications

Thanks for your suggestions.

[tm_burgers]

Set the Name of your column in Qlik to :

=$(vQuarter)&' Goals' & =$(vQuarter)&' Applications' 

Respectively, and then in nPrinting just make sure that you use the header tag!