Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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