topic Re: Excel Pivot table based on dynamic column labels in Qlik NPrinting

Excel Pivot table based on dynamic column labels

Anonymous — Thu, 12 Oct 2017 12:36:18 GMT

Hi,

following the instructions on NPrinting help https://help.qlik.com/en-US/nprinting/17.2/Content/ExcelReports/HowCreatePivotTableExcelTableColumns/Pivot-table-Excel.htm?_ga=2.98079007.1091868254.1507558724-1187855711.1490870490

it's easy to create Excel pivot tables based on QlikView straight table data but I cannot figure out how to achieve the same result when source data includes dynamic column labels (i.e. text and variables/formula concatenated)

For example, whit a table like that transformed in Excel table and then summarized:

Customer	Sales <YEAR>
Customer 1	100
Customer 2	10
Customer 3	5

I end up with an Empty Excel pivot table since column name has changed, i.e. "Sales 2017", and Excel is not able to automatically add it to the pivot since it references objects by name.

Is there any way to achieve that in NPrinting 17.5?

Thanks!

Re: Excel Pivot table based on dynamic column labels

mkelemen — Thu, 12 Oct 2017 23:22:17 GMT

Hi Giuseppe,

yes this is an excel limitation.

You can work around it - export the Sales year in separate column and then use it in the pivot table as column label.

BR,

Matus

Re: Excel Pivot table based on dynamic column labels

mstoler — Thu, 01 Oct 2020 11:41:47 GMT

Hello,

Is there any update on this?

I also have the same problem where I have dynamic column names in Qlik Sense that I would like to use in an Excel Pivo table.

Thanks,

Michael

Re: Excel Pivot table based on dynamic column labels

Lech_Miszkiewicz — Thu, 01 Oct 2020 20:51:02 GMT

Purely from Excel point of view this is not possible @mstoler . It always was and is excel limitation.