Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik_aparna
Partner
Partner

Difference between year along with months

Hi Everyone,

I want to find the difference between dates along with the months. Example Date1 is 2032-01-15 and Date 2 is 2021-02-22 the expected difference is 10years and 11 months so it should appear as 10.11. Using Year(Date1) or Month(Date1) is not giving expected answers. Any help on this?

Labels (2)
1 Reply
rbartley
Specialist
Specialist

It depends on your data structure.  Do you mean you have 2 fields and you want to find the difference or that you want the difference between one date and another in the same field.  If you also post your app, it will be easier to answer.