2 Replies Latest reply: Jun 14, 2018 4:21 AM by Daniel Rodríguez RSS

    Diff Date depending on other table

    Daniel Rodríguez

      Hi all. First of all thank you for your time.

       

      There is an issue I can not solve, but I'm sure there is something I'm missing.

       

      Let's say I have two different tables in qlik:

       

      IDDateADateB
      IDType

       

       

      In my script I want to calculate the difference between DateA and Date B in months and then create some buckets, but depending on the type. I think there are several ways to achieve this:

       

      • Create a mapping table to get the type in the first table. Problem? There is no function to calculate the number of months between two dates (Am I right?)
      • Calculate the type in the Script on the first table but in this case I lose the flexibility of having the second table in an Excel and whenever I want to change it I just have to change the excel and everything changes.

       

      The last way that comes to my mind is to calculate the number of months between both dates in a variable inside the APP,  but there is no function to calculate the number of months between two dates



      Is there a way to achieve this?

       

      thanks you for your time.

       

      Regards