Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
DestinedTale
Contributor II
Contributor II

Interval at load script not showing negative

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. 

1 Reply
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

FABS() function returns the positive number of calculation.

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

Hope this helps.