Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sampada0810
Creator
Creator

Dynamic headers in PowerPoint Qlik NPrinting template

Hi All,

I'm trying to rank region dimension on sales, for doing so the headers in the Qlik Sense are populated using firstsortedvalue() and rank(). Is it possible to change the header in the back-end excel table i.e. as per the screenshot below, I want to create dynamic header instead of series 1,series 2 etc. in PowerPoint template Qlik Nprinting.

Capture.PNG

Thanks,

Sampada

1 Reply
Eva_B
Employee
Employee

Hello Sampada,

Which version of Qlik NPrinting are you using? Depending on your response, this may alter my answer.

However, with the latest version, please see the below information on Excel Reports:

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ExcelReports/Full-Excel-Table.h...

With regards to the headers it states the following:

Set Show Headers to Show above tag cell for the columns of the table.

HideQlik NPrinting will not add headers. You can type them, or obtain dynamic headers using QlikView variables and Excel formulas.

Show in tag cell: column headers will be inserted in the tag cells and data will start in the row below. Formulas and variables in original QlikView headers will not be replaced.

Show above tag cell: column headers will be inserted in the row above tag cells. Data will start on the row with the tags. Use this option when column headers in the original QlikView documents use variables or formulas and you want them to be reported in the table.

If this helped answer your question, please mark as "Solution."


Thank you,

Eva