Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator II
Creator II

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

Capture.PNG

 

ZZ