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?
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.