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:
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