topic Re: Export excel in text format in QlikView

Export excel in text format

Somasundaram — Sat, 16 Nov 2024 21:41:30 GMT

Hi Qlikers,

I am trying to export the values like 1-2,2-3,3-4,4-5 as excel file. But, I am getting the values as 1-Feb,2-Mar,3-Apr,4-May

I have tried in script, text(field) and changed the values 1*2,2*3,3*4,4*5 and replace the * as '-'. text(replace(field),'*','-') but, I am getting the same.

help would be appreciated.

Thanks,

Somasundaram

Re: Export excel in text format

Anil_Babu_Samineni — Wed, 26 Dec 2018 13:15:54 GMT

Please check, If any custom format cell applied in Excel?

Re: Export excel in text format

Somasundaram — Wed, 26 Dec 2018 13:28:27 GMT

Hi,

Yes. Custom format is applied.

Re: Export excel in text format

karthikoffi27se — Thu, 27 Dec 2018 08:17:23 GMT

Hi Soma,

Please refer the below link and try any one of the options mentioned below.

https://support.office.com/en-us/article/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8

Many Thanks

Karthik