Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Export to Excel -> Pivot formatting

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

Labels (4)
4 Replies
Highlighted
Partner
Partner

Hi Prisma,

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

Jordy

Climber

Work smarter, not harder
Highlighted
Partner
Partner

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?

Highlighted
Partner
Partner

Hi,

Not that I know now..

Jordy

Climber

Work smarter, not harder
Highlighted
Partner
Partner

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 ?