Qlik Community

Qlik Sense Documents

Documents about Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER

Math & Statistics in Qlik Sense - app included

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

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

Partner
Partner

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

0 Likes
Partner
Partner

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

Partner
Partner

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

 

BR,

Maria

0 Likes
Luminary
Luminary

@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
Partner
@JaMajka1 Great work!! I'm very much looking forward for more. Thank you!
MVP & Luminary
MVP & Luminary

Well done. Thanks.

Thanks for very useful app!

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

0 Likes
Luminary
Luminary

Hi Maria,

great work.

Do you plan any updates in the near future?

Please could you add the version of your app on the first page?

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

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