topic Re: Formatting issue when exporting timestamp in QlikView

Formatting issue when exporting timestamp

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

Hi all,

In my .qvw i have a variation N/N-1. It appears correctly but when i export in Excel, negative value are not formated and appears as number.

I use as expression =Interval ($(I_value_N) - $(I_value_N_1),'mm:ss')

In QlikView:

In Excel:

Thanks

Miguel_Angel_Baeyens — Thu, 11 Jan 2018 13:56:59 GMT

What is the real value displayed in Excel?

sergio0592 — Thu, 11 Jan 2018 14:06:20 GMT

For row 2 (-20 seconds), it's -0,000234419705586556

For row 5 (-1min and 05 seconds), it's -0,000752718546070723

zebhashmi — Thu, 11 Jan 2018 14:23:45 GMT

Hi - you can't show time in Negative (as its a part of Date) Value in Excel you can add in formate if it will work for you

zebhashmi — Thu, 11 Jan 2018 14:37:09 GMT

May be this can help

sergio0592 — Thu, 11 Jan 2018 15:58:12 GMT

Thanks, works with checking Use 1904 Calendar in Excel options