topic Re: Interval at load script not showing negative in QlikView

Interval at load script not showing negative

DestinedTale — Wed, 05 Jan 2022 05:06:48 GMT

Hi, I have a load script where this formula fabs(floor(num(interval(Performa_Window_Date - [Last BTR Cust], 'm'))*24*10)/10), 0) as diff for Performa_Window_Date: 28/12/2020 01:00:00 and Last BTR Cust: 14/01/2021 10:00:00
should be -417 but it is showing as 417 in the chart.

Re: Interval at load script not showing negative

AshutoshBhumkar — Wed, 05 Jan 2022 05:27:40 GMT

Hello,

FABS() function returns the positive number of calculation.

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/GeneralNumericFunctions/fabs.htm

Hope this helps.