YEARFRAC Function In qlik

[Gowtham174]

Hi Team,

In Excel we have function called YEARFRAC , is there a same function in Qlik.

Start Date	Maturity date	YearFrac
2020-02-04	2020-08-04	49.73%
2020-02-04	2021-02-04	100.00%
2020-02-04	2023-02-04	300.07%
2020-02-04	2025-02-05	500.36%

Thanks,

Gowtham

[sunny_talwar]

I think you are using Basis = 1 in your calculation, right? I believe Excel has it way of determining the actual number of days in the year. I am unable to determine how exactly does it estimate this... To answer your question, there is no easy function which would do this for you, but if you can estimate the denominator, numerator can be determine by doing Maturity date - start date.

[Sue_Macaluso]

@Gowtham174 Are you using QlikView or Qlik Sense? I would like to move this into the correct product forum.