Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to calculate RMSE in QlikSense

How do I calculate RMSE in QlikSense

5 Replies
mvanlutterveld
Contributor II

Re: How to calculate RMSE in QlikSense

Hi,

If you mean with RMSE the root mean square error, there’s no such ready-for-use function in Qlik Sense. Qlik Sense has got many statistical functions (check the help) that should enable you in calculating the RMSE. Check Wikipedia here and here for more background of the RMSE.

I'm aware I didn't really answer your question but I hope this will help a bit.

Cheers, Michiel

Not applicable

Re: How to calculate RMSE in QlikSense

Yeah, I meant root mean square error. I tried googling and wiki but wasn't able to come up with a formula

undergrinder
Valued Contributor II

Re: How to calculate RMSE in QlikSense

Hi Shivam,

This link may help you:

Root Mean Squared Error | Kaggle

2016-06-23 13_45_36-Root Mean Squared Error _ Kaggle.png

G.

mvanlutterveld
Contributor II

Re: How to calculate RMSE in QlikSense

Well it's not Qlik Sense but I think this post can help you

MVP
MVP

Re: How to calculate RMSE in QlikSense

Something along these lines:

=sqrt(Sum(sqr(val1 - val2)) / Count(val1))


Where val1, val2 are the y and y' values. This assumes that val1 and val2 are properly associated with a 1:1 relationship. Substitute the correct field names for your document.