Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

I want to adjust the column width when outputting data of a pivot table object.

sis
Partner - Specialist
Partner - Specialist

I want to adjust the column width when outputting data of a pivot table object.

When data is output from the right-click menu for a pivot table object
Data can be output to an Excel file, but after the 5th column with a certain number of columns,
Excel cells are not automatically adjusted and are narrowed, and the display (appearance) is "###"
Will be displayed.

The same phenomenon occurs even if you export the data using the following API function.

exportData method
https://help.qlik.com/en-US/sense-developer/November2021/Subsystems/APIs/Content/Sense_ClientAPIs/Ca...


information
・ Browser uses Edge
・ Use Office365
·Qlik Sense Server May 2021
・ No dependence on the terminal

I will attach a trail.証跡1.jpg

2 Comments
Meghann_MacDonald

Hi @sis , unfortunately I think this is an issue with excel rather than Qlik Sense. When opening any excel doc, the columns are narrowed and standardized, I believe. @Andrew_Kruger can you answer that question?

Meghann

Andrew_Kruger
Employee
Employee

Please re-test with the QSEoW  Download with formats from Qlik Sense Feb 2022 - feel free to contact support if you see this continuing.  

Status changed to: Closed - Archived