11 Replies Latest reply: Sep 9, 2016 4:20 AM by Jivesh Singh RSS

    exporting from qlikview to excel the date format to be mmm-yy

    Jivesh Singh

      Hi,

      When I export data to excel the date format is not kept the same as in the Qlikview model. I have my SET DateFormat='MMM-YY';, but when it exports to excel it exports as "dd-mmm" format.

      However, if I export for a few months which is less data it exports fine, but once i export for more months which is more data (more records), it exports as "dd-mmm" format !

      Anyway around this to be exported in the same format as the model which is "MMM-YY"??

       

      Regards, Jivesh