topic YEARFRAC Function In qlik in App Development

YEARFRAC Function In qlik

Gowtham174 — Fri, 02 Apr 2021 08:20:00 GMT

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

Re: YEARFRAC Function In qlik

sunny_talwar — Thu, 20 Feb 2020 17:31:55 GMT

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.

Re: YEARFRAC Function In qlik

Sue_Macaluso — Thu, 20 Feb 2020 18:55:42 GMT

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