NPrinting Excel Table Dynamic Column Headers

Pomna — Fri, 16 Oct 2020 21:58:54 GMT

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.

Re: NPrinting Excel Table Dynamic Column Headers

tm_burgers — Mon, 09 Nov 2020 20:25:26 GMT

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!

topic NPrinting Excel Table Dynamic Column Headers in Qlik NPrinting

NPrinting Excel Table Dynamic Column Headers

Re: NPrinting Excel Table Dynamic Column Headers