Qlik Community

Deployment Framework

Announcements
Submit your remarkable customer story for the Global Transformation Awards at QlikWorld Denver 2022. SUBMIT A STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
JaMajka1
Partner
Partner

Math & Statistics in Qlik Sense - app included

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 v1.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

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

  • Outliers & extreme values – why and how to identify them
  • Financial functions with interactive examples
  • Linear regression with examples not only for prediction
  • Combinatorics examples
  • Statistical distribution functions

Thanks, @RadOresky  for your help and review of the app 😉.

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

Maria

2 Replies
JordyWegman
Partner
Partner

Hi Maria,

Nice work you have done here! Though, your part of kurtosis needs a change while with a negative kurtosis the outlier character of the distribution is less extreme than that of a normal distribution. In your text, you state the opposite, while in your examples you show this the right way. Example two is less extreme than for example the random one. 

Jordy

Climber

Work smarter, not harder
JaMajka1
Partner
Partner
Author

Thanks, Jordy you are right 🙂 Good to know that someone really read the content 😉 Are there any functions you would like to see in the next version?