Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Contributor III

Excel pivot table - NPrinting 17.3


In my Nprinting excel report, I am creating an excel pivot table from qvf data. Now above the table headers I want to have another header row. I created a formula for the same whose value is a static string like "current time". But when I drop the formula on the cell above the pivot table header, the value is not displayed. Only the formula name( <formula_name>) appears. But if I place the same formula in a cell outside the pivot table columns, it is coming correctly. How can I correct this?

2 Replies
Esteemed Contributor III

Re: Excel pivot table - NPrinting 17.3

can you show the picture?

Honored Contributor III

Re: Excel pivot table - NPrinting 17.3

My understanding is that Pivot tables are created based on existing data.

What you are trying to do is to enter a value in Pivot Tabel (not editable) area - that will never work.

As sugested by Chanty - provide a screenshot of:

  • what you are doing
  • what is your result
  • what is expected result



cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser