Announcements

# Math & Statistics in Qlik Sense - app included

No ratings
cancel
Showing results for
Did you mean:

## Math & Statistics in Qlik Sense - app included

Last Update:

Feb 24, 2020 1:23:47 AM

Updated By:

JaMajka1

Created date:

Jan 13, 2020 7:14:50 AM

I like mathematics and see the potential it is not only in robotics or “almost sci-fi” technologies but everywhere where data is generated and should be understood.

I like Qlik, its possibilities and simplicity for end-users at the same time.

However, when it comes to mathematics and Qlik together, a lot of people think about SSEs – python or R – and default Qlik math functions are underestimated. I think there might be two reasons – Qlik users do not know about them or do not understand when these functions can help them. So, I decided to develop a Qlik app that will get you an overview of default mathematical functions in Qlik with a little bit of theory and above all, examples and exercises. All of them are interactive – thanks to Qlik 😉.

In the QS Math & Statistics app v3.0 you can find:

• Quiz to test your skills with Qlikculator I am very proud of 😄 (what to do for 5 hours in a train without wifi)
• An interactive overview of basic math functions with examples
• Descriptive statistics – theory, example, and my thoughts:
• Measures of central tendency
• Measures of variability
• Percentiles, quartiles, fractiles
• Measures of distribution
• Overview of different datasets
• Intro to correlation
• Financial functions
• Overview with the Payment calculator
• Future Value & Present Value

If you will find the app useful, in next versions I will add:

• Outliers & extreme values – why and how to identify them
• Financial aggregation functions (IRR, NPV, XIRR, XNPV)
• Linear regression with examples not only for prediction
• Combinatorics examples
• Statistical distribution functions

I hope you will like it. Any recommendations are very welcome 😉,

Maria

Tags (3)
Luminary Alumni

Very nicely done!

Most people don't know that the cephes maths library is embedded in the Qlik engine, it's just not all exposed. If there are functions you'd like access to you just need to lobby the product development team, they love that! 😉

Rod

Thanks Rodj, good to know! I will definitely work on version 2.0 of the app ;). And who is the right contact for the discussion with the product development team? 🙂

Partner - Contributor III

Nice!.

What version of Sense are you using?

I'm currently getting an error with the container extension you are using since it's not the same as de dashbordbundle tabbed-container.

Best regards

Filip

Thanks, Filip for your comment :). I developed it by using QS Desktop November 2019.

BR,

Maria

Luminary Alumni

@JaMajka1  sadly I don't know the answer to that question any more, so many people have moved on since I worked at Qlik. Your Qlik partner manager should be able to tell you but I'll dig around and see what I can find out.

Partner - Contributor III
@JaMajka1 Great work!! I'm very much looking forward for more. Thank you!

Well done. Thanks.

Partner - Contributor II

Thanks for very useful app!

Former Employee

Cool app!

The qlik-button-for-navigation extension was removed from the dashboard bundle. With newer versions of QS (>=April2020) errors are displayed, because the extension object is missing.

Luminary Alumni

Hi Maria,

great work.

Do you plan any updates in the near future?

In the version I'm using is under "coming soon" mentioned Outliers and financial aggregation function"

Thanks again for sharing and I hope that you could book some train-tickets 😉

BR

Martin

Contributors
Version history
Last update:
‎2020-02-24 01:23 AM
Updated by: