Transpose aolumns to row NPrinting excel report form Qlik Sense

[jesus_gomez]

Hi everyone,

we are facing an issue that we are trying to solve wihout pivot tables. We want to build an excel report in NPrinting from a straight table in Qlik Sense.

The issue is that we need to set a report like this:

	jan-19	feb-19	mar-19
	MTD Sales	MDT Sales	MTD Sales
Product A	9886	6457	3448
Product B	123	456	789

Any ideas??As I mentioned above, our client doesn't want a pivot table, because he wants to update that final excel report.

Thanks in advance

Jesus

[Ruggero_Piccoli]

Hi,

If the customer doesn't want a native Excel pivot you could:

- create the same table in Qlik Sense and export it

- create an Excel macro that reorder the columns in produced reports and trigger the macron on file opening

Note that Excel pivot tables created from Qlik NPrinting export a native Excel table with native data, so the customer could update that table and the pivot will be consistent.

Best Regards,

Ruggero