Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!