topic MONTH converting into number while exporting data to EXCEL in QlikView

MONTH converting into number while exporting data to EXCEL

himabinduch — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i have below monthly field in script leave which working fine , but while im exporting the same from access point it is converting my month field into number. pleas help me on the same.

dual(mid(FISCAL_MONTH_NAME,12,3),FISCAL_MONTH_NUM) AS DT_FISCAL_MONTH_CRD

Re: MONTH converting into number while exporting data to EXCEL

Arthur_Fong — Wed, 19 Feb 2020 09:16:44 GMT

Duplicate the month field into 2:

dual(mid(FISCAL_MONTH_NAME,12,3),FISCAL_MONTH_NUM) AS DT_FISCAL_MONTH_CRD,

mid(FISCAL_MONTH_NAME,12,3) as FISCAL_MONTH

Use FISCAL_MONTH at front end table.