Qlik Community

Qlik Sense Documents

Qlik Sense documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Math & Statistics in Qlik Sense - app included

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

Thanks, @radoresky  for your help and review of the app 

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

Maria

Attachments
Comments
w_nascimento
Partner
Partner

What a great app, congratulations!

Johan_Kassing
Contributor II
Contributor II

Hi Maria, thank you so much for making this app. QlikView and Sense are indeed underestimated for their statistics and math possibilities. 

0 Likes
Nahum_Zamora
Contributor
Contributor

Muchas gracias. muy buen aporte. Esperamos que la nueva versión sea tan buena o mejor que esta. Saludos.

0 Likes
pauljohansson
Creator III
Creator III

I believe you are spot on. Most users don't even look for statistical functions in Qlik "because that's for R or Phyton"

 

Really looking forward to an updated version that includes K-means 🙂

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