Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Qlik Gallery is meant to encourage Qlikkies everywhere to share their progress – from a first Qlik app – to a favorite Qlik app – and everything in-between.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Picasso.js is a powerful charting library that plays really well within the Qlik Sense ecosystem to build simple or very complex visualization.
By leveraging its component-based nature, you can combine the building blocks to create virtually any type of chart.
To learn more about Picasso.js, I recommend the following resources:
The full documentation of the library can be found on qlik.dev at https://qlik.dev/libraries-and-tools/picassojs. Navigating the documentation is easy, you can dig deeper into the main concepts, learn more about the different types of supported scales, but more importantly discover the different components that you can mix and match to create unique visualizations.
A feature of Picasso that I really like but is not very clear from the docs is Theming.
Picasso.js is themeable meaning that you can easily control the look and feel across all visualizations by creating a theme and changing a few base variables.
To do that, you simply pass in a theme object when instantiating Picasso js as follows:
…
Import picassojs from ‘picasso.js’;
…
const picasso = picassojs({
style: {
'$font-color': '#FF00FF',
'$font-size': '10px',
'$font-family': 'Arial',
'$font-size--l': '16px',
'$guide-color': '#00FF00',
'$shape': { // for use with type point component
fill: '#00FF00',
strokeWidth: 1,
stroke: 'rgba(255, 255, 255, 0.2)',
shape: 'star',
},
},
palettes: [{
key: 'categorical',
colors: [
chroma.bezier(['#00FF00', '#0000FF']).scale().colors(5),
],
}, {
key: 'sequential',
colors: [
['#00FF00', '#0000FF'],
],
}],
});
Notice that you can change the labels’ font styling, colors, and even shapes of points (star, triangle, etc..) on the style object, and also pass in a color palette for categorical and sequential color scales.
The result looks like this (the ugly colors are for demo purposes only!)
Below is the complete code of the settings file and attached is the full project to run and edit.
/* eslint-disable no-unused-vars */
import {
useElement,
useState,
useStaleLayout,
useRect,
useEffect,
} from '@nebula.js/stardust';
import picassojs from 'picasso.js';
import picassoQ from 'picasso-plugin-q';
import chroma from 'chroma-js';
export default function supernova() {
const picasso = picassojs({
style: {
'$font-color': '#FF00FF',
'$font-size': '10px',
'$font-family': 'Arial',
'$font-size--l': '16px',
'$guide-color': '#00FF00',
// $shape: { // for use with type point component
// fill: '#00FF00',
// strokeWidth: 1,
// stroke: 'rgba(255, 255, 255, 0.2)',
// shape: 'box',
// },
},
palettes: [{
key: 'categorical',
colors: [
chroma.bezier(['#00FF00', '#0000FF']).scale().colors(5),
],
}, {
key: 'sequential',
colors: [
['#00FF00', '#0000FF'],
],
}],
});
picasso.use(picassoQ);
return {
qae: {
properties: {
qHyperCubeDef: {
qDimensions: [],
qMeasures: [],
qInitialDataFetch: [{ qWidth: 2, qHeight: 5000 }],
qSuppressZero: false,
qSuppressMissing: true,
},
showTitles: true,
title: '',
subtitle: '',
footnote: '',
},
data: {
targets: [
{
path: '/qHyperCubeDef',
dimensions: {
min: 1,
max: 1,
},
measures: {
min: 1,
max: 1,
},
},
],
},
},
component() {
const element = useElement();
const layout = useStaleLayout();
const rect = useRect();
const [instance, setInstance] = useState();
useEffect(() => {
const p = picasso.chart({
element,
data: [],
settings: {},
});
setInstance(p);
return () => {
p.destroy();
};
}, []);
useEffect(() => {
if (!instance) {
return;
}
instance.update({
data: [
{
type: 'q',
key: 'qHyperCube',
data: layout.qHyperCube,
},
],
settings: {
scales: {
x: {
data: {
extract: {
field: 'qDimensionInfo/0',
},
},
},
y: {
data: { field: 'qMeasureInfo/0' },
invert: true,
expand: 0.1,
},
c: {
data: { field: 'qMeasureInfo/0' },
type: 'color',
},
},
components: [
{
type: 'axis',
dock: 'left',
scale: 'y',
},
{
type: 'axis',
dock: 'bottom',
scale: 'x',
settings: {
line: {
show: true,
},
},
},
{
type: 'grid-line',
x: 'x',
y: 'y',
},
{
key: 'bars',
type: 'box',
data: {
extract: {
field: 'qDimensionInfo/0',
props: {
start: 0,
end: { field: 'qMeasureInfo/0' },
},
},
},
settings: {
major: { scale: 'x' },
minor: { scale: 'y' },
box: {
fill: { scale: 'c', ref: 'end' },
},
},
},
],
},
});
}, [layout, instance]);
useEffect(() => {
if (!instance) {
return;
}
instance.update();
}, [rect.width, rect.height, instance]);
},
};
}
企業におけるデータの役割が急速に進化し続ける中、データリテラシーはこれまで以上に重要になっています。データリーダーは、受け身の BI モデルからアクティブインテリジェンスへと移行し始めています。リアルタイムのインサイトにアクセスし、迅速な意思決定と情報に基づいたリアルタイムのアクションを起こすには、能動的な分析への移行が不可欠です。
迅速な意思決定ができていない最大の障壁の 1 つにデータリテラシー不足が挙げられます。つまり、データを読み取り、活用、分析し、データとのコミュニケーションスキルが不足しているのです。かつてないほどデータから得られる機会が増えている今、情報に基づいたアクションを取るためには、必要なスキルアップと文化の変革を早急に検討する必要があります。
本 Web セミナーでは、新着レポート「データリテラシー:スキルアップの革新」の調査結果をはじめ、受け身の分析から能動的な分析に移行して、ビジネスの加速およびデータリテラシーを促進する方法をご紹介します。
能動的な分析への移行におけるデータリテラシーの重要性について、ぜひご確認ください。
As we were working on one of our projects, we had the need of creating multiple combo charts. The problem was that we could not change the colors to match our mashup/webpage. So, I decided to make an extension, that gives full control of the chart appearance and it's labels. The same as my Barchart extension this is wrapping text labels underneath the bars. If you still have problems with the text, then just increase the width of the bars and everything should be back in place.
Installation
- [Download zip file](https://github.com/yianni-ververis/SenseUI-ComboChart/archive/master.zip)
- Desktop - Unzip at the extension folder (C:\Users\<user>\Documents\Qlik\Sense\Extensions\SenseUIComboChart)
- Server - Upload the zip file
Usage
Dimensions and Measures
- Set 1 dimension for the x Axis
- Set 1 Measure for an additional Line Chart
General Settings
- Font Size
- Font Color
- Display the Legend
- Enable/Disable Selections
Bar Chart Settings
- Bar Color
- Bar Hover Color
- Bar Width (0 for auto scaling)
- Bar Border Color
- Bar Border Width
Line Chart Settings
- Line Color
- Line Width
- Dot Color
- Dot Stroke Color
- Dot Stroke Width
- Dot Radius


Barnch: http://branch.qlik.com/#!/project/5894e07a75db504d76ac3123
Git: GitHub - yianni-ververis/SenseUI-ComboChart: Qlik Sense Combo Chart
Yianni
The TC Ice Cream Application project provides students a structured approached to learn the basics of Qlik Sense. A variety of visualizations, master dimensions/measures and variable input are topics that are covered within the project.
This video provides an overview of the project:
Business Requirements Document:
https://drive.google.com/file/d/1vUNgJQB0ZyJuTzlIBL-T7Q41u4YjbvmN/view
Videos related to the development and functionality of the TC Ice Cream Application can be found on the following You Tube Playlist :
https://www.youtube.com/watch?v=1h_Pvr-aiT4&list=PLl4F1FsqnyHD6Wz9Q63qxqp9EnIpkqfNt
If you have any questions please let me know.
Thanks - Jerry
Every month our Academic Program team meets with our Educator Ambassadors to get inspired by guest speakers and customer stories or knowledge share and ask questions. Some of our most interesting sessions are those in which our Educator Ambassadors present on how they incorporate the Academic Program into their teaching.
There are a variety of ways in which educators have used our program, from embedding the assessments to including portions of the instructor led training videos in classes. However, it is often the case that students starting the course have different strengths and weaknesses, and varying levels of data literacy. During our meeting last Friday one of our educators explained that his students are required to take a Qlik data literacy assessment before beginning their course, this then helps to him to understand what training and resources could be useful to the students. This level test, our Data Literacy Persona Assessment, is provided for free by Qlik. It can be accessed through our ‘Data Literacy Program’ which you can navigate to inside the ‘Self-Paced Learning’ section.
It can be found at the bottom of the page under the subheading ‘Assessments’, you will then be directed to sign in with your Qlik ID to gain access to the test.
Our Data Literacy Persona test takes minutes, it includes 15 different questions and can be used to assess your current knowledge level and then establish the next steps in your training. Some of the questions are geared towards those already working in industry; however, it is still possible to answer the questions as a student to better understand both knowledge level and attitude. For example, are you a data newcomer? Someone who understands the importance of data but still needs to learn the foundations. This test will help you find that out, and once you have the results, you will be provided with a custom learning plan to help you get started on your journey.
Your learning plan will detail a variety of ways to get started, whether that be content available to you through the Qlik Continues Classroom, interesting YouTube videos or blogs and podcasts. The learning plan is themed around the crucial indicators of data literacy, for example reading, working with, analyzing and communicating with data. It is intended to be done over the course of 8 weeks, giving you optimum time to dip in and out of study when it’s most convenient.
If you have recently gotten access to the Academic Program but you don’t know where to start with all the resources available to you, then understanding your knowledge level with our Data Literacy Persona test could help you take that first step. To understand more about how you can access the test through our Academic Program, go to qlik.com/academicprogram.
Out of 30,697 shots, Kobe's favorite type was the jump shot. He was dominant across the entire NBA for 20 seasons. He could score from nearly any position on the half court, and had a number past half court as well.
Using sports data in this fashion on a scatter plot is applicable to many business use cases where positional data is present. Mapping over top of images like a basketball court, warehouse floorplan, or airport terminals opens up a wide array of possibilities of displaying data in more consumable ways.
Data geeks, Qlik dorks, and sports nerds will love this branded app.
Visualizing 30K+ points on a scatter usually yields little insight - but by combining with the basketball court as the background, the data comes to life to tell a story.
Qlik Espresso Web セミナーシリーズでは、Qlik 製品のプロフェッショナル達が Qlik 製品の簡単な概要、製品デモンストレーション、使用例についてご紹介します。
本 Web セミナーは、毎月 1回・最大 30分間の内容でお送りします。
コーヒーを飲みながら、短時間でお気軽に参加できる Web セミナーシリーズです。ぜひ、ご視聴ください。
オンデマンド配信:
データをビジネス成果へ結びつけるデータ活用プラットフォームとは -「目的」ではなく「手段」としてのデータ活用 -
ビジネスにおけるデータ活用。かねてよりその重要性が説かれていましたが、新型コロナウイルスによって加速度を増し、今後ますます重要度が高まっていくと予想されています。リアルタイムなデータのビジネスへの活用が企業の将来を左右する、と言っても過言ではありません。
この講演では、Qlik が掲げるビジョンである「アクティブインテリジェンス」」を具現化するリアルタイムのデータ活用プラットフォームと、その具体例についてご紹介します。
オンデマンド配信:
『DNP の価値創造プロセス』を実現するためのデータ利活用の推進
DNP 様におけるビジネス推進のためのデータ利活用について、インタビュー形式で実際の取り組みを具体的に語っていただきます。ビジネス課題を解決するためのアクションと成果とは?Qlik 導入を機に全社におけるデータ活用への取り組み、今後の展望などを語っていただきます。ぜひ、ご参加ください。
The main metrics should be displayed as KPI objects and the other metrics can be analyzed as alternative measures in the charts. The 2 bar charts provide users with the ability to compare metrics and freely explore the data selecting an alternative dimension. The botton line chart allow user to see trends of each metric along the time.
We have applied this template to rapidly release the locked data and let Business Users explore and validate the data even before building a dashboard.
All users that need to engage with analytics for the first time with a simplest interface.
This template can be improved with forecasting analysis and trend lines. Any data can be analyzed using this template.
Understanding the journey for a user to rapidly build out an Qlik Sense App through the SaaS platform. Along with Build my own analytics tool to allow me to compare activity statistical data, speed, stroke rate, distance, etc.. .
Rapidly build out an insightful app through SaaS with the objective of visualising, analysing and understanding my activity tracker data in a more intuitive and flexible manor, beyond the functionality the tracker vendor or 3rd party provided analytics functions.
The audience for this app was me personally
The data and analytics within this app has provided me with the ability to compare similar activities in order to understand effort, performance and time improvement through my training program.
Some of the discoveries from using this app include:
* Key demographics at different hierarchical levels: population size, rates of births, deaths, and natural increase.
* RNI for each state, division, and region compared to the national average.
Helps estimate and project population counts and shifts to draw conclusions and make decisions in respect of the current and future distribution of social and economic resources and activities at national, regional, divisional, and state levels.
Demographics analysts, researchers, and planners seeking to understand the size and change of populations. All who want to analyze hierarchical data structures in Qlik Sense — the app features a good example of a Sunburst chart and is publicly available among AnyChart demo apps for Qlik Sense.
The dataset is derived from Kaggle.com: “United States Energy, Census, and GDP 2010-2014.” It contains demographic data from the United States Census of 2010.
What is a regression line? In simple terms, it is a line that best describes the behavior of a set of data. They are often used for forecasting to illustrate the relationship between the dependent y variable and the independent x variables when there is linear pattern. Using a regression line can show future behavior of the dependent variable using different inputs for the independent x variables. Scatter plots now support regression lines and provide many options to choose from. In the properties pane of the scatter plot chart under Add-ons, is an option for Regression Lines.
Click the Add Regression Line button to add a regression line to your chart. There are many types to choose from depending on your data and what you would like to show. According the Qlik Help, here are the regression line types available to add to a scatter plot chart.
Here are some regression line examples:
Average
Linear
Second Degree Polynomial
Fourth Degree Polynomial
There are some additional properties that can be set for a regression line. The color of the line and label can be set, and the line can be displayed as solid or dashed. The direction of fit can also be set to either minimize vertically or minimize horizontally. A scatter plot can also have more than one regression as seen in the chart below.
Regression lines are helpful for analysis because it allows us to see patterns in our data. They allow us to see the relationships between two or more variables and examine which variables may have an impact. Check them out - Qlik Sense makes it easy to use them in your scatter plots charts.
Thanks,
Jennell
Hello Qlik Community!
QlikWorld 2022 is less than a week away! Are you all excited?! We sure are!
If you’re not already registered, you may do so here. Qlik Community will be a part of the “Let’s Connect!” booth, so stop by and say ‘Hi’!
I cannot believe it’s May already – in the US that means schools are winding down and summer is coming! Bring on the sunshine, pool, and BBQ! For the Qlik Community, that means we have some hot new updates for you!
Products are primarily used within our Support Knowledgebase and Release Notes. We’ve cleaned up the products list to make filtering easier. We also condensed Qlik Sense Enterprise SaaS and Qlik Sense Business to one product, Qlik Cloud.
Use the new Qlik Cloud Change Log card on the Product News carousel for easy access to what’s new in Qlik Cloud. A link to the Help page has also been added to the Qlik Cloud release notes (going forward).
Have you reached an inaccessible area on Qlik Community? The message directs you where to go for assistance, but we’ve also added the Chat Bot to the page so you can easily reach out to Customer Support for assistance!
Typically, we would be on a freeze until July but we are just too excited to wait for the upcoming enhancements! Check back in a few weeks for a few new updates!
Your Qlik Community Admins,
Melissa, Sue, Jamie and Nicole
1. Afternoon is the preferred time of day for occasional members. Afternoon accounts for 47% of total trips per day. 2. The summer months are the most popular of the year for occasional members and they account for 52% of the annual period. 3. Following the introduction of electric bicycles, we noticed an increase of 59% in their use by occasional members during their first 3 months and a decrease of 30% of bicycles at the dock during this same period. 4. We noticed occasional members keep the bikes almost 3 times longer than the annual members. 5. In summer, trips for occasional cyclists are concentrated near the beaches, unlike the rest of the year.
The marketing recommendations we came to a conclusion are the following: 1. Offer flexible weekend subscriptions for occasional cyclists between 4 p.m. and 6 p.m. at the most popular stations: Streeter Dr & Grand Ave, Lake Shore Dr & Monroe St, Theater on the Lake and Lake Dr & North Blvd. 2. As the number of cyclists increases on Friday and last the entire weekend, the marketing team may offer discounts to speed up membership for occasional cyclists. 3. Make the dockside bicycle stations more accessible and available depending on the start and ending place of the journey. 4. Create a loyalty program in the form of bonuses / rewards for occasional rides who cycle for long kilometers. A smartwatch could be a great reward. 5. Send a newsletter via email every Thursday evening with the unusual places in the region, the latest discounts and news from Cyclistic. 6. Collect the body mass index in order to track trends.
The app is made for the marketing as well as the financial team of the company in order to make business decisions on the next months.
N/A
App with data under the link: https://drive.google.com/file/d/1gRIoiU6C_bqariyC3AiWkqkPM3PrY6w_/view?usp=sharingApp with data
Learn about all the great new capabilities in our Client-Managed Qlik Sense offering:
Augmented Analytics
Now offering Business Logic – allowing users to define the default grain for a calendar period, such as on a yearly, quarterly, or monthly basis. When users create behaviors such as default calendar periods, they can now specify whether to use or ignore the grain for a particular analysis, providing more advanced fine-grain controls.
New Visualization & Dashboarding capabilities
The May 2022 release of Qlik Sense Enterprise on Windows includes several data visualization features that were previously released in Qlik Sense SaaS. With this release, we have expanded the variety of and added flexibility to your data visualization options based on user feedback. Our new scatter plot allows you to add regression lines, including average, linear, exponential, logarithmic; and second, third, and fourth polynomial. Regression line color and type can be set, and vertical or horizontal fit can be specified. Next, our updated, more flexible variable UI surfaces all variable elements, including name, description, value, and tags; and allows you to add search, and duplicate variables. The addition of background colors and icons in the KPI object provides more ways for you to customize Qlik Sense, as you wish. Additional capabilities and enhancements like buttons and coloring options have been added to various areas, improving usability and convenience, while adding clarity, speeding time to insight, and expediting data-driven decision making. Finally, to help with your transition to SaaS, we have enacted a 12-month grace period for GeoAnalytics extensions in Qlik Cloud. Following the grace period, you can use the map chart, which is faster, easier to use, prints better, and includes more features.
Expanded Connectivity
To start, the Qlik Web Storage Provider Connectors are now available in Qlik Sense Enterprise on Windows in the same way as in Qlik Sense SaaS. The corresponding metadata connectors are also integrated, without the need for Qlik Web Connectors separately installed. These connectors allow you to connect to file-based data stored on a web storage provider, either by browsing for folders and files directly in the UI, or via the separate metadata connectors listing the structures and objects in tables. The web storage provider platforms supported are Amazon S3, Azure Storage, Dropbox, Google Cloud Storage, Google Drive, Office 365 Sharepoint, and OneDrive.
Also, the Oracle Connector in Sense SaaS now provides additional security capabilities with support for the upload of an Oracle Wallet file. An Oracle Wallet holds authentication credentials, private keys, certificates, etc., and thus enables organizations to easily enforce security rules based on defined user privileges contained in an Oracle Wallet. The Oracle Connector can now access Oracle via a TLS encrypted communication channel.
Platform enhancements:
Includes new capabilities to make your App Distribution from Qlik Sense Client Managed to a Qlik Sense SaaS Tenant even more robust and scalable. Introducing a new Task type -> Distribution Task Re-Distribute an App with Data only if the Data blob has been updated
Hybrid Use Case Improvements
On top of releasing capabilities to further improve our Hybrid use cases, we released a new installation tool to help you upgrade your PostgreSQL Database as part of your Qlik Sense Client Managed installation. For the consumer-driven use cases, we released the ability to add favorites in the hub. Administrators will benefit from an improvement in the Management Console which makes it easier for them to globally replace extensions (and/or upgrade existing extensions).
To access this build: Download here
REGISTER FOR QLIK INSIDER providing more details on this release and new deliveries to Qlik Cloud!
Have you ever tried to compare two dates that looked the same to find out that in fact they were different? I was recently approached by a colleague who had this problem. In their script, they were adding a flag when the date in a field was also the last day of the month. Both dates were formatted to show the month, day and year (M/D/YYYY) but the flag was never true even when the dates appeared to be the same. When working with dates, you may find that although two dates are formatted the same, the underlying values may be different. To troubleshoot this, we used the Num function to get the numeric value of the two dates we were comparing in the script to see if the two dates were the same numerically. Take a look at the table below for an example of how we resolved the issue.
Steps Date 1 Date 2 Notes
| Start with these dates | 2018-10-05 05:16:50 | 10/5/2018 | |
| Format Date 1 to display the date like Date 2 is formatted | Date('2018-10-05 05:16:50', 'M/D/YYYY') >> 10/5/2018 | 10/5/2018 | |
| Is Date 1 = Date 2? | 10/5/2018 | 10/5/2018 | No, not equal |
| Use Num() to see numeric value of dates | Num(‘2018-10-05 05:16:50’) >> 43378.220023148 | Num(10/5/2018) >> 43378 | The numerical values of Date 1 and Date 2 are not the same |
| Use Floor to round Date 1 down to just the date | Num(Floor(‘2018-10-05 05:16:50’)) >> 43378 | Num(10/5/2018) >> 43378 | |
| Using Floor, is Date 1 = Date 2? | Num(Floor(‘2018-10-05 05:16:50’)) >> 43378 | Num(10/5/2018) >> 43378 | Yes, they are equal |
So let’s explain what is going on here. We started with 2 dates – one that had a timestamp and one that did not. After formatting the dates the same, it was determined that the dates were not equal. This is because the underlying numeric value of Date 1 still included the time even though the time was not visible after it was formatted as M/D/YYYY. The numeric value of 2018-10-05 05:16:50 is 43378.220023148 while the numeric value of 10/5/2018 is 43378. When looking at the numeric values, the value before the decimal point represents the date and the value after the decimal point represents the time. To handle this, the Floor function was used. According to Qlik Sense Help,
Floor() rounds down a number to the nearest multiple of the step shifted by the offset number.
Compare with the ceil function, which rounds input numbers up.
Syntax:
Floor(x[, step[, offset]])
Once the floor function was used, Date 1 was rounded down to just the date, giving it a numeric value of 43378 - the same as Date 2.
It is helpful to remember that dates have numeric values. We often see dates formatted to meet our needs which is great but when we need to compare dates, we need to look beyond the displayed date and look at the numeric date. The Date function controls how the date is displayed but it does not change the underlying value of the date. In this example, the Floor function rounded the timestamp down to just the date. The Ceil function works similarly except it rounds up. You can also check out Henric Cronstrom’s blog titled Why don’t my dates work? for other date related issues you may stumble upon. I hope you find this blog helpful and that it helps you quickly troubleshoot date comparison issues should they arise.
Thanks,
Jennell
What Is Qlik Reporting Service?
Qlik Reporting Services is a public API that provides the ability to compose multi-page outputs from your apps, leveraging your curated analytics in a report format. It can be easily used from within Qlik Application Automation or can be integrated into customers’ systems directly. Qlik Reporting Service is available to our Qlik Sense Enterprise SaaS customers. This is our first major release on our cloud reporting journey and together with Qlik Application Automation it reimagines report task management using a low code/no code report process definition. Centralized reporting teams can now in a matter of a few inputs define burst reports to support management or operational reporting requirements and leverage their cloud eco-system to source recipients, and configure distribution channels.
We see three areas where our customers will reap immediate benefits with Qlik Reporting Service:
Qlik Reporting Service is now available to all Qlik Sense Enterprise SaaS customers and includes 100 reports per tenant per month defined as a document output of a reporting services call.
We are excited about our latest data analytics innovation for the cloud. We invite you to revisit, rethink and reexamine your potential for reporting in the cloud with Qlik Reporting Service.
To learn more visit: Qlik Reporting Service video playlist and for all the latest SaaS enhancements visit our SaaS Change Log
Add Help to your Qlik Sense Application
When you need to provide more details to a chart, such as a definition, tip, or note, you can add a container tab with text and image object. This not only gives users context, but also reduces clutter when you need to add more information that is not specified within the chart.
Add Reference Lines in Charts
It’s often necessary to add context to metrics presented in charts and dashboards. This helps data consumers and decision makers easily see key points within your chart. By adding reference lines for 50% and top 5 as dynamic indicators, additional perspective is displayed.
Grid Chart with Pie Charts
Using a grid chart with pies can help users visualize KPIs over time or with different variables like regions. To do this, you can re-use the map chart with the chart layer.
Table Indicators
By adding table indicators, you can enrich your tables with context, allowing users to immediately identify outliers and understand key metrics. Table indicators can include rank, trend, and status markers to simplify the interpretation of values. Below you will see how to add table indicators in Qlik Sense.
Icicle Chart
Helpful in showing hierarchies, you can create an icicle chart by modifying the pivot chart. To determine the space you need, sort by the first measure and count the leafs. Make sure “totals” are turned “on,” so you can sort by the first measure. To color by number of leafs, use the colormix function. You can reduce clutter utilizing pivot buttons and condensing the header with CSS multi-KPI.
Icicle Chart with Deviation
Finally, the deviation icicle chart provides users with a simple way to see the differences between metrics over time. For example, you can quickly show a number increase or decrease in units sold or bookings month over month using the deviation icicle. This type of chart is created using the combo with stacked bars for the deviation and white bar as the offset. First, add lines with actual and forecast, turn on labels, and set forecast to transparent =argb(0,0,0,0). Next, add bars for offset=min(Actual,Forecast) and deviation. Then, color the offset bar transparent =argb(0,0,0,0) and deviation red for – and green for +. Finally, add a marker layer for lollipops.
As you use Qlik Sense SaaS more and more, you will clearly see how Qlik’s world-class visualization capabilities stand ahead of other analytics companies when it comes to supporting your innovation today and in the future. For more information on these and other data visualization capabilities, check out Qlik’s Visualization Showcase. See this eBook for tips on avoiding common data visualization pitfalls.
The Qlik Academic Program is being leveraged by many Universities in Australia and New Zealand. More than 45 Universities from ANZ are using the academic program resources to enable the student and educator community in analytics.
A local study by Arktic Fox and Michael Page Australia has identified data and analytics as the number one skill gap in marketing teams. Most marketing leaders say data literacy was not strong in their departments. To fulfill this gap and also a growing demand for data analytics resources, the Qlik Academic Program provides top class analytics software, training, qualifications, certifications to University students and professors, completely free.
The University of Tasmania (UTAS) has been partnering with the Qlik Academic Program for a number of years now. Each year, Charlie Farah, Senior Director, Solutions and Value Engineering at Qlik presents to the students on all things data and analytics.
Dr. Joel Scanlan from UTAS who collaborates with Charlie on this initiatives says, “ We are very grateful to Charlie for his time and continued support”
The primary course is the Master of Health Information Management which aims to equip students with a strong awareness of the role that data and information have on modern healthcare, with particular interest in Data Analytics, Privacy and Security, ethics, and governance. A number of these components are also covered in the Graduate Certificate in eHealth also.
Charlie is invited to present to students enrolled in subject BAA735 Health Data Management, Information Analysis and Improvement which delves into key theories and approaches in health data management and information. Frameworks and models for information analysis and reporting are also investigated, including strategies for measuring and monitoring organisational and clinical outcomes and experiences. Something world leading data & analytics software is critical for.
Students get practical hands on with a range of data, including a deep dive into a dataset of their own choosing using Qlik Cloud. This equips them to be able to analyse and understand data, to see its impact not only on clinical outcomes, but also the efficiency of care delivery and better equip them for their roles ahead.
Joel Scanlan further says that they look forward to continuing this partnership for many years ahead. The Qlik Academic Program is happy to work with UTAS and forge a strong partnership to enable its students and professors in data analytics.
For more information about the academic program, visit: qlik.com/academicprogram