Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bcr123psu
Contributor II
Contributor II

Exporting Pivot Table to Excel is Formatted as Text

Looking for some feedback.  I tried applying the suggestion from a few different QlikView threads using a Round() function within an expression without luck (output is still formatted as text).

Qlik Sense App:

PivotTableSense.png

Excel Output:

PivotTableExcel.png

 

We have no problems exporting from a standard table object as a value but the pivot table object is exporting only as text and I'm hoping there is an easy workaround for this.

Many thanks in advance.

1 Reply
zzyjordan
Creator II
Creator II

can you provide more details or sample qvf as it is not easy to be reproduced.

Capture.PNG

 

ZZ