Export to Excel -> Pivot formatting

[Danijel]

Hello everyone,

current (QS Feb 2019 SR1), the problem when exporting a pivot table to Excel is that neither color definitions nor number formats are accepted.

Is there a trick here how to get the whole thing nice in Excel? Or will Qlik make an adjustment soon?

Thank you and greetings

[JordyWegman]

Hi Prisma,

Try the Vizlib Pivot Extension for this. Here you can export the Formatted Data to Excel.

Jordy

Climber

[Danijel]

Hi Jordy,

Thanks for the suggestion. A good possibility in itself, but I would like to distribute the whole thing later with NPrinting, and there are currently no extensions supported.

Is there a possibility from the Qlik Sense standard?

[JordyWegman]

Hi,

Not that I know now..

Jordy

Climber

[ghaliabed]

Is this still the case with the latest versions ?

The out of the box pivot table also seems not to export formatting information correctly.

Also for vislib, those are paid components correct ?