Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mickael_weqan
Partner - Contributor III
Partner - Contributor III

Export a field in xls in txt on pivot table and num in straight table

Hello community,

On QlikView 11.2 SR9

we've got an On Demand analysis which allow us to create pivot table or straight table, but we've got an issue with the Send To Excel functionality :

On straight table, when exporting the Year, it's a numeric value

On pivot, Year is text value.

We forced numeric format on the app directly but nothing change and the two export don't get the same field format.

How could we export on pivot and straight table Year in numeric?

Thank you,

Mickael.

1 Reply