Discussion board where members can get started with QlikView.
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')
Go to Solution.
May be this can help
What is the real value displayed in Excel?
For row 2 (-20 seconds), it's -0,000234419705586556
For row 5 (-1min and 05 seconds), it's -0,000752718546070723
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
Thanks, works with checking Use 1904 Calendar in Excel options