Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sergio0592
Valued Contributor II

Formatting issue when exporting timestamp

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

1 Solution

Accepted Solutions
zebhashmi
Valued Contributor

Re: Formatting issue when exporting timestamp

5 Replies

Re: Formatting issue when exporting timestamp

What is the real value displayed in Excel?

sergio0592
Valued Contributor II

Re: Formatting issue when exporting timestamp

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

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

zebhashmi
Valued Contributor

Re: Formatting issue when exporting timestamp

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

Capture.PNG

zebhashmi
Valued Contributor

Re: Formatting issue when exporting timestamp

sergio0592
Valued Contributor II

Re: Formatting issue when exporting timestamp

Thanks, works with checking  Use 1904 Calendar in Excel options