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?