Skip to main content

Math & Statistics in Qlik Sense - app included

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
JaMajka1
Partner Ambassador
Partner Ambassador

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

Attachments

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

Comments
Rodj
Luminary Alumni
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

JaMajka1
Partner Ambassador
Partner Ambassador

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
filip_tinglof84
Partner - Contributor III
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

JaMajka1
Partner Ambassador
Partner Ambassador

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

 

BR,

Maria

0 Likes
Rodj
Luminary Alumni
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.

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

Well done. Thanks.

Viktor_Hirschner
Partner - Contributor II
Partner - Contributor II

Thanks for very useful app!

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

0 Likes
martingries
Luminary Alumni
Luminary Alumni

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
Contributors
Version history
Last update:
‎2020-02-24 01:23 AM
Updated by: