1 Reply Latest reply: Mar 13, 2018 9:17 AM by Ishtdeep Singh RSS

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

    Mickael Briet

      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.