is there any YEARFRAC function in qlikview or any alternative for this?

[#1]

Hi,

Anyone know the how to use YEARFRAC function in qlikview or is there any alternative for this?

could you please help me to calculate below formula in qlikview.

= 1 / (YEARFRAC(E_TestStart, E_TestEnd, 1))

Regards,

Vedant

[Clever_Anjos · Accepted solution]

Please Try

= 1 /  ( (E_TestEnd - E_TestStart) / 360)

[#3]

Thanks Clever Anjos