9 Replies Latest reply: Oct 30, 2015 9:51 AM by Justin Walcott RSS

    Date Calculations

    Justin Walcott

      Hello,

       

      I am wondering if there is a way in Qlik Sense that I can create an expression that takes two date fields and does a mathematical calculation with them to then output the measure of a graph.

       

      The calculation is fairly simple, as it would be   (Date1 - Date2) / 365

       

      It just seems currently I am unable to do this, I think the output is null as I just get a flat line in my line graph. It makes sense because Dates are not whole numbers so logically it makes no sense to minus them or divide them. So if anyone has any input on how I can make this expression work I would be very greatful.

       

      Thanks,

      Justin