6 Replies Latest reply: Apr 5, 2018 11:26 AM by William Christensen RSS

    Modulo chart function (Qlik Sense 3.2)

    William Christensen

      Good Morning Everyone,

       

      I am trying to figure out why my mod function isn't working as I expected.

       

      =Interval(Now(0)-Packing_DtTm,'DD')

      The above line gives me the number of days and works fine.

       

      =mod(Interval(Now(1)-Packing_DtTm, 'mm'), 1440)

      The above line is supposed to produce the number of minutes without the day portion since that is included in the day calculation.

       

      https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/GeneralNumericFunctions/mod.htm

       

      I am not sure what I am missing. I checked Packing_DtTm with isnum and it appears to be a real date. Any help you can provide would be greatly appreciated!