Alternative to T.INV.2T Excel function in Qlik

[abidev]

Hello,

So I am new to Qlik Sense and I am converting a legacy report over to Qlik Sense. I would like to use a Statistical function T.INV.2T which is available in Excel in Qlik. We have TINV and TDIST functions but not this one. I am not a Statistician so I do not know what are the alternatives to this function or if there is a way at all to have it in Qlik Sense. Please advice.

Thanks,

Abi

[Andrea_Spinetti · Accepted solution]

Hello @abidev 👋, actually the TINV function should return the same results as T.INV.2T in Excel. Have you tested and compared the results between QlikSense and Excel? 

[abidev]

Thanks @Andrea_Spinetti for your pointer. It was spot on and I was able to validate the results. TINV in Qlik and T.INV.2T in Excel actually have the same results.