5 Replies Latest reply: Jun 23, 2016 10:29 AM by Jonathan Dienst

# How to calculate RMSE in QlikSense

How do I calculate RMSE in QlikSense

• ###### 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

• ###### 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

• ###### Re: How to calculate RMSE in QlikSense

Hi Shivam,

Root Mean Squared Error | Kaggle

G.

• ###### Re: How to calculate RMSE in QlikSense

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

• ###### 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.