Skip to main content

Suggest an Idea

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

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Exporting Formatted data to Excel from Pivot and Straight Table

lisaratliff
Contributor III
Contributor III

Exporting Formatted data to Excel from Pivot and Straight Table

Ability to export formatted data to Excel from Pivot and Straight Table similar to Vizlib table export.

2 Comments
Yuki_Suzuki
Employee
Employee

I agree.
Especially good to keep the right-justification of the numbers.
In addition, please support for different formatting depending on the result, such as in the following formula.

Pick(ID,Num(SUM(Sales),'#,##0'),NUM(SUM(Sales)/SUM(TOTAL Sales),'#,##0,00%'))

Meghann_MacDonald

Hi @lisaratliff , this has already been submitted and formatting updates are being tracked here: Keep formatting on Excel Export 

 

Meghann

Status changed to: Closed - Duplicate