A few months ago I stumbled upon a fantastic app that showcase the not very well known math functions in Qlik. The app does a great work popularizing math & statistics using default Qlik functions. Ever since I put my hands on the app I wanted to blog about it.Explore the app here:https://showcase3.qlik.com/sense/app/c863e07b-87bc-4d0f-a6e1-92f3289b4f56More info and app download here:https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Math-amp-Statistics-in-Qlik-Sense-app-included/ta-p/1665018I asked the app's author, Mária Šándorová@JaMajka1to introduce the app:I started to develop the app like this the same year I started to work as a full-time Qlik developer. For me it was a good way how to explore mathematical possibilities together with script and expressions syntax of a great tool that was new to me. After that it didn’t have my focus for some time. And then there was a boom of advanced analytics and predictions. Qlik community, different blogs, even my own presentations and Qonnections were full of SSE – possibilities how to utilize mathematical power of R or python for these algorithms. They are great tools with their advantages in more complex algorithms and a good step forward for Qlik that it can be integrated with them. However, I think that because of all these information and materials about advanced analytics for Qlik in R or Python or anywhere else, we started to underestimate Qlik’s own capabilities. When someone needs to calculate a correlation, identify outliers, run k-means clustering or test data normality, we really don’t need to use an external tool – we can use Qlik’s default functions as are or script an algorithm within Qlik. I spent days building this app and I still haven’t covered many areas like hypothesis testing or linear regression. Not to mention algorithms you can script within Qlik. So there really are many advanced analytics and statistics possibilities integrated within Qlik itself, too. I think it’s amazing that we have different options on how and where to calculate something! And I believe that for being able to make a good choice, we need to consider our options and the first step is to know we have it 😊. So, exploring Qlik’s capabilities in statistics was the first reason to create this app. It defines the content of it. The structure and design of the app is driven by something different. I really like data literacy initiatives and I believe we need to help people become data intelligent and understand their data. I know, this app is more about mathematics than about context and visualizations, but I think it’s also an integral part of the data intelligent company – even if not necessary important for all users. And what is a better way how to understand the function if not having a simple use case and a generated dataset in an interactive tool? I love the idea of trying possibilities and seeing the results in the same second. In advanced sections of the app you can select a subset of data in two clicks and thanks to Qlik, everything is recalculated! Select outliers only and see the results of mean and variance … select excluded values and see their results… That’s brilliant for understanding what’s going on! And if you prefer specific formulas and definitions, they are there, as well 😉.I hope you like it as much as I do
...View More
Join me this Thursday to learn about my new webinar series.Sign up here:https://go.qlik.com/Do-More-with-Qlik-Webinar-Series?_ga=2.59309549.1553862558.1591019803-2011899493.1579200524
...View More
QlikWorld Online is approaching fast so we created a Session Guide to keep you informed about the many sessions that are staff and partners and customers will be providing.Check out the Guide here:https://showcase3.qlik.com/sense/app/b8c838ac-38b8-4064-9b41-0d22b056ce6dLet me know if you have any questions.
...View More
Let's check out how we can build an animated rank chart with picasso.js! You can check out an example in the History of the Fortune 500 app that we built for Fortune athttps://qlik.fortune.com/.In this post I'm going to review the picasso.js settings for building an animated rank chart. For the chart to be animated, you'll also need to implement something like I covered in my last blog post about animating picasso.js athttps://community.qlik.com/t5/Qlik-Design-Blog/Animations-with-picasso-js/ba-p/1686543.DataFor this example I'm going to use dimensions and measures like we were using the q picasso plugin. You'll want to have 1 dimension and 2 measures. The first measure should be the value you are ranking, and the second measure should be a rank expression.SettingsThe general idea here is that we need to calculate the position of the bars along the y-axis such that as we interpolate the change in the rank the position will change. We also use a labels component in place of an axis component for the y axis labels, since the labels component will attach to the bars and move along with the bars, as opposed to the y-axis, which would be a band scale axis that has discrete positions. Here's what the settings are, with some comments to explain.{
scales: {
y: {
data: {
extract: {
field: 'qDimensionInfo/0',
props: {
rank: { field: 'qMeasureInfo/1' }
}
},
sort: (a, b) => a.rank.value - b.rank.value, // sort values in scale (in case we use brushing or something
},
padding: 0.2,
},
x: {
data: { field: 'qMeasureInfo/0' },
include: [0],
expand: 0.5, // you need to use expand so the labels fit, may need to adjust based on length of your labels
},
},
components: [
// this is the main box component
{
type: 'box',
key: 'bars',
displayOrder: 1,
data: {
extract: {
field: 'qDimensionInfo/0',
props: {
start: 0,
end: { field: 'qMeasureInfo/0' },
rank: { field: 'qMeasureInfo/1' }
}
}
},
settings: {
major: {
scale: 'y',
// this is what positions the bars on the y-axis
// the reason we calculate the position manually is so that as we interpolate the change in rank it will animate
fn: (d) => (d.datum.rank.value * d.scale.step()) - (d.scale.paddingOuter() * d.scale.bandwidth()) - (0.5 * d.scale.bandwidth()),
},
minor: { scale: 'x', ref: 'end' },
orientation: 'horizontal',
},
},
// we use these labels instead of an axis component for animation reasons.
// we can attach the labels to the bars so they animate along with the position of the bars
{
type: 'labels',
displayOrder: 2,
settings: {
sources: [{
component: 'bars',
selector: 'rect',
strategy: {
type: 'bar',
settings: {
align: 0.5,
justify: 0,
fontSize: 14,
direction: 'left',
labels: [{
placements: [{ position: 'outside', fill: '#666' }],
label: (node) => node.data.label,
}],
padding: {
top: 0, right: 8, bottom: 0, left: 0,
},
},
},
}],
},
},
// these are the value labels
{
type: 'labels',
displayOrder: 2,
settings: {
sources: [{
component: 'bars',
selector: 'rect',
strategy: {
type: 'bar',
settings: {
align: 0.5,
justify: 0,
fontSize: 11,
direction: 'right',
labels: [{
placements: [{ position: 'outside', fill: '#666' }],
label: (node) => node.data.end.value,
}],
padding: {
top: 0, right: 0, bottom: 0, left: 6,
},
},
},
}],
},
},
],
}Now you need to do is interpolate the change in the rank value when updating the chart, and you'll have an animating rank chart. You can also check out these settings athttps://observablehq.com/@fkabinoff/rank-chart-that-can-be-animated-by-interpolating-rank-chang.
...View More
Sample App attached below - unzip and import using QMC (Windows) or Upload via SaaS and cloud-based Qlik Sense deployments - using the Add New button.Did you know that all versions of Qlik Sense allow you to designate specific selections and visualizations to interact with one another - independently of the default selection state. Therefore you can make different value selections on the same dimension and compare those results in two or more visualizations side by side. Check out this 60 second video and links below to learn more and start adding comparative analysis do your analytics.How to: https://www.youtube.com/watch?v=LMMGAFgrnc8 Learn more:https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Alternate%20States.htm
...View More
Today Nicole Tamms from Qlik introduces you to our new Analytics Modernization Program. The Analytics Modernization Program increases choice and lowers friction for new and existing customers. The Analytics Modernization Program enables customers to deploy exclusively in Qlik's cloud, providing ease of management and a lower TCO. You can also deploy on premise or within private cloud-based based on your governance needs and data requirements, with the option of adding our SaaS to benefit from Qlik's unique multi-cloud architecture.Watch this brief video where Nicole will tell you more.
...View More
When creating a load script, you often use data from files, e.g. xls, csv, txt, or qvd. By default, absolute paths to the folders are generated when the library is created. But what if you want to use relative paths? What do you do then?
With the Qlik Sense April 2020 release, the Org Chart was added to the Qlik Visualization bundle. The Org chart provides a way to visualize hierarchies in your data. In this blog post, I will review how easy it is to create an Org chart provided you have the hierarchical data structure in your data model. Below is a snapshot from an Excel file that was loaded. It has the employees within a company and who each person reports to.The things to note in this file are:Every employee has a unique Employee ID.The Manager ID is the Employee ID of the employee’s manager.This spreadsheet is designed to go 5 levels deep (EmpName 1 through EmpName5) but additional columns can be added or removed as needed. Other supporting employee data can also be added to the data model to use in the org chart or in other charts in the app.To begin, add the Org chart to a sheet. The Org chart takes 2 dimensions and 1 measure. The first dimension added is EmployeeID. In the Org chart, each employee will have their own card. In the properties for the EmployeeID dimension, other information that you would like to show on the card for each employee can be added.In this example, the card title has been set to EmployeeName, the sub-title to the employee’s title and the card description to the employee’s salary. There are some colors loaded in the data model so the field, Color2, was selected coloring the cards by the employee’s title. The second dimension added to the Org chart is the Reports To field. This field stores the EmployeeID of the employee’s manager like the ManagerID field. There is also the option to add a measure. In this example, a measure was not added. If a measure is added, it will be visible when you hover over a card. That’s it – that is all that needs to be done to add an Org chart to your Qlik Sense app.Now, let’s take a look at the Org chart. By default, the Org chart will show 2 levels when you come to the sheet.If an employee is a manager, there will be a number under their card indicating the number of employees that report directly to them. Clicking on that number will open the cards of their direct report(s). When there is a plus sign (+) that means that there are cards that are not visible. Once the cards of a manager are opened, it will turn into a minus sign (-) to indicate that the card is opened. This is visible in the image below.The Org chart provides an easy way to see the hierarchical structure within an organization. Users can zoom in and out in the chart as needed and Qlik Sense will handle closing cards if newly opened cards may overlap or get in the way. Check out this chart and other new features of the Qlik Sense April 2020 release in the resources listed below.Demo: What's New - Qlik Sense April 2020Video: What’s New – Qlik Sense April 2020Video: April 2020 Feature DemonstrationBlog: Qlik Data Analytics Product Release - April 2020 Thanks,Jennell
...View More
With the design work to introduce Spaces, available in Qlik Sense cloud deployments discussed in Part 1 and Part 2 of this series, todayFredrik Lautrup is back with Part 3 - sharinghow his team added the ability to secure Qlik Sense data connections within the Spaces apps are created in.With the introduction of spaces and the content life-cycle we have created a number of concepts and a way of working with content that we think a lot of our customers will be happy with. But not all customers are alike, we will always have customers that want to do more. Luckily the spaces concept with some of its more advanced space functionality allow for this flexibility to adapt to customers’ needs to work with and protect their data. If we start with the movements of apps and its relations to data, we have introduced the concept of space aware data files and data connections. This means that data files and data connections can be stored in spaces and referenced in different ways to its location. The permissions are always applying to the current user, but this might be used to build out some interesting structures.So first let’s go through how this works in the data load editor......Download the PDF attachment to learn more.Want to experience Qlik Sense now - start your free trial here:https://www.qlik.com/us/trial/qlik-sense-business
...View More