Qlik Community

Qlik Sense App Development

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

mickael_weqan
New 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
isingh30
Contributor III

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