Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This space offers a variety of blogs, all written by Qlik employees. Product and non product related.
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
This blog was created for professors and students using Qlik within academia.
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.
Per Statista, the big data market is growing rapidly, with $42 B USD revenues in 2018 and a massive increase to an expected $1.89 B in 2019. Corporations are adopting new technologies to help manage integration and draw insights from big data. In the telecommunications industry alone, around 94.5 percent of respondents representing the telecommunications industry stated that their organization currently used big data technology as of 2018.
The increase in big data has created the need for employees with specific skill sets, people who the industry call Data Scientists! According to LinkedIn, there has been a 56% increase in data scientist job openings in the US since 2018, and a recent report by Indeed revealed a 29% year-over-year increase (and 344% increase since 2013). Aside from the many business insights that can support sales, marketing and product development, mining user data and making it available to fuel artificial intelligence and machine learning is considered the new gold rush by many venture capitalists. For the full story on the hot market for data scientists visit CIO - Data Science
Now is the time for university students to get a head of the game and learn the vital skills needed to land these coveted jobs. The Qlik Academic Program has the tools and resources needed so that students can learn Qlik Sense, a leading BI tool and receive a certificate to put on their resume!
Professors and students should visit us to learn more and apply today!
We all know that data scientists are in high demand. In fact, Amazon says that job opportunities for these experts have grown by 505% over the last 5 years. With the Internet of things producing more data than ever before, it’s easy to see why all organisations want people who can make sense of big data to drive them to success. But what does this mean for market researchers? Can data science really replace them all together?
Last week raconteur.net discussed this very question, with input from various experts in the field. Aidan Slingsby, director of City, University of London’s MSc in data science, discusses how data science can be “an exceptionally useful tool for market research professionals”.
However, he also adds that market researchers are still essential in understanding the context of the information provided by data scientists, and to interpret the ‘what’ from the ‘why’. Ben Page, chief executive of Ipsos MORI goes on to explain how observational research is still essential, using a real-life study conducted for a global pet food manufacturer as a case in point.
The conclusions drawn here is that data science and market research should work hand in hand to deliver clearer and more granular insights that ever before. You can read the full article here:
https://www.raconteur.net/business-innovation/research-experts-big-data
If you are teaching or studying market research at the University level and want to delve into the world of data science, you can sign up for the free Qlik Academic Program. This will give you access to Qlik Sense analytics software as well as a library of e-learning materials and free qualifications. This includes a product agnostic data analytics curriculum to get you started in topics such as statistical concepts and theories in analysis.
Sign up here today: qlik.com/academicprogram
In an interesting article on Wharton School's portal, the evolution of a data analyst role from someone working with transactional data to that of analytics "your grandmother would understand" is spoken about. There is a great deal of emphasis on skills as an analyst which one must acquire including creative communication, story telling , actionable insights etc. The ex Chief Data Officer Wells Fargo defines a Unicorn as a person who understands data and can explain it to business and that is the person one must hire for an analyst's role.
Its an interesting read which you must not miss: https://knowledge.wharton.upenn.edu/article/evolution-of-chief-data-officer/
In fact, the Qlik Academic Program offers training in precisely the same set of skills that has been emphasized in this article for a top notch data analyst, to know more about this program, visit: Qlik.com/academicprogram
Today - Jeff Goldberg is back as our latest guest blogger and will introduce us to Qlik Sense QMC Utilities. Jeff is a Senior Enterprise Architect on the North America Enterprise Architecture team who has worked in various technology positions for over 16 years. Jeff focuses on integration, deployment, automation, security, and api topics across a wide range of software. Thanks for this valuable contribution Jeff!
Good day Qlik Community! Recently you may have seen this logo popping up on Qlik Community, Qlik Branch, or on the Visualize Your World tour. It represents our add-on capabilities that support our initiatives to provide Governed Self-Service and Power tools for Qlik Sense, created by the North America Enterprise Architecture team. Today, the EA PowerTools team would like to introduce you to their latest release known as QMC Utilities.
QMC Utilities
QMC Utilities is a collection of tools using the Qlik Sense APIs to automate and streamline a variety of processes within the management and administrative areas of Qlik Sense. In the initial release, the team released three helpful tools to make configuring and administering a Qlik Sense deployment easier.
Custom Property Bulk Loader: One of the unsung capabilities in Qlik Sense is the ability to add custom attributes to resources within Qlik Sense. These custom properties help in numerous ways to manage a Qlik Sense environment, from providing local group type attributes, to users, to creating dynamic security rules that have broad applicability and reduce the risk of “rule creep”. Unfortunately, adding custom property values can take some time as it requires key entry. The Custom Property Bulk Loader solves this problem by enabling administrators to load a list of values into an existing or new custom property for Qlik Sense.
Rule Manager: The Rule Manager makes it easy to export and import rules from one Qlik Sense site to another. Rules are selected from the list, exported to json with all the necessary information to import the same rule into another environment.
Want to download this great set of tools and learn more? Head over to the EA Powertools community page to download this solution and have a look at the other great things this team is building to enhance Qlik Sense!
Regards,
Jeff Goldberg
Follow me: Jeff Goldberg (@goldbergjeffrey) | Twitter
Continuing the line charts topic I've started a few weeks ago, let see how to adjust a line chart to help us to see what we want to.
In the example below I want to display Sales evolution by store over time, but it happens that this company has too many stores (lines) to easily identify them individually in the chart.
I still can get some value out of this chart; global trend is still visible. Seems like sales are decreasing over time, but details are lost in the color mess.
As color is not helping me to better decode this chart, I will unify line colors.
Now I can see much better my company’s trend, sales amount is decreasing, based on the overlap of individual store behaviors but details are still hidden in green.
Selecting a store I could isolate it and get its details. This is great and fast, but it avoids me from seeing the selected store in context. What I would like to see is the sales evolution of particular store vs all others.
The next step will be to avoid the chart to be filtered out when a store name is selected, to do so I will include set analysis in my expression.
Original expression: sum(Sales)
New expression: sum({<Store=, [Store Name]=>} Sales)
By doing that my chart won’t be filtered by Store or Store Name selections
Now, what I need is to highlight the store within the chart. Again I will use the Background Color properties for the expression to achieve that.
if(isnull(only([Store Name])) ,ARGB(20,200,200,200),ARGB(190,43, 123, 70))
This expression will gray out all non-selected stores and highlight our selection(s).
With this new chart, my selections will help me to see store details and to keep selected store(s) in context. I can see the global trend and compare it with any store just by searching and selecting.
Extra tip: If you look carefully at the two charts above, you may notice a slightly color difference in the second image dark green line, this is because the green line is under several semi-transparent gray lines making it look little bit different.
Sorting the dimension will help you to prevent this. In this case I’m sorting Store Name by sales amount using the following expression.
aggr(sum(Sales),[Store Name])
You can see this chart working as part of Retailer EPOS Data Analysis demo.
These are some creative and really cool non-standard uses of line charts I have seen lately:
Parallel Co-Ordinates Chart
This chart variation was firstly introduced by Alistair Eaves some time ago. The chart is great for showing data paths between various dimensions; letting people to understand something so hard to see as flows dynamics in the data. Check out the demo
Dynamic Network Flow Charts
If you are a frequent flyer you will probably have read all magazines in your front pocket. One of my favorites readings on board are these maps with all the routes airlines operate through the world. Matthew Crowther stretched out QlikView line chart object to display information in the same way but keeping the QV soul (association) in it. If you want to know how to do it, you should read: New Qlikview Chart Type: Dynamic Network Flow Charts | QVDesign
The Associated Curve Chart
Based on the same principles but pushing things a little bit more Matthew presented this new chart, he called Associated Curve Chart. You can check it out at Matthew's blog
Enjoy Qliking!
AMZ
We have hit the halfway mark of 2019 with the third release of the year, and momentum at Qlik remains strong as we continue to deliver significant product innovations across the Qlik Product Portfolio.
The June 2019 Product Release offers a wide range of new capabilities. Qlik Sense includes new visualizations and advanced authoring features, improvements to our multi-cloud deployment framework, and Qlik Sense Mobile enhancements. We also have new Qlik NPrinting and Qlik Associative Big Data Index features, along with the much anticipated QVD Catalog in Qlik Data Catalyst.
When building an app, there are certain functions that I use over and over again. This is the case when I need to add a Quarter field to my data model. I often have dates in my apps and sometimes I like to provide the user with a Quarter field so I thought I would share the script that I often use. Below is the script I always use to create a Quarter field in my data model.
When creating the Quarter field, I use the Ceil function. The Ceil function can be used in the script or a chart and it rounds a number up to the nearest multiple of the specified step interval. You cannot talk about the Ceil function without mentioning the Floor function. The Floor function does the opposite of the Ceil function by rounding numbers down. Both functions have a third parameter, the offset, which allows you to increase or decrease the result of the Ceil or Floor function by a specified value. Let’s take a look at some examples.
The syntax for the Ceil function is:
Ceil(x[, step[, offset]])
The Floor function does the same as the Ceil function except instead of rounding up, it rounds down. Let’s take a look at the same examples and see how the results vary.
The syntax for the Floor function is:
Floor(x[, step[, offset]])
So now let’s apply the Ceil function to determine the quarter from a date. The script I like to use is:
If we break this down, we first use the Month function to return the month number and then we divide that by 3 since there are 3 months in a quarter. So assuming the OrderDate is December 11, 2015, Month(OrderDate)/3 will return 4 (12/3=4). Then the Ceil function is used to round that number up. The script above also uses the Dual function so that we can display the Quarter as a string, Q4, with a numeric value of 4. This makes it easier to sort charts that use the Quarter field.
The Ceil and Floor functions provide rounding capabilities with the ability to set the step as well as an offset. If I had a cheat list of scripts I like to use, this Quarter script would be on the list. What would be on your list?
Thanks,
Jennell
Today’s corporate environment is global. QlikView application developers are required to support many regions and many languages. So how does a QlikView application developer handle multiple languages? Well, that depends on how the data is captured and the overall goal of the application developer. Let’s look at two scenarios.
Scenario 1: The developer only needs to translate the labels and textboxes within the application and not the actual data.
=Only({<Index={12}>} [$(=vDataLanguage)])
for all textbox and object captions that need to be translated.
Scenario 2: The data from which the QlikView application developer is developing is recorded in English but he/she needs to have some of the actual data translated into other languages.
=$(vIndustry).
That’s it! Easy, right? Well, it is a bit time consuming if you are trying to translate data in fields but translating text and labels is really not that difficult. I created a technical overview that walks you through the two scenarios mentioned in this blog as well as a third scenario which can be found here. This resource includes a How-To, sample data files and 2 QVWs.
Good luck with the translations! Lycka till med översättningarna! 翻訳で頑張ってください!
The latest Qlik Sense June 19 version ships with a nice new feature that should let anyone to embed or share a chart in style.
It’s simple, find the chart you want to embed and right-click on it, you should access to the context menu where you could for example see the data table for the chart you are looking at. In this case what we want to click on in that menu is the option called “Embed Chart”. Note if your screen mode is set to touch, you will find this option by touching in the vertical ellipsis (aka Kebab Menu) icon.
That will pop a window up with a nice preview of the chart and some options that are very handy.
You can customize how you can interact with the embedded object.
You can select if you want the user to be able to interact with the embedded object.
You can select if you want the context menu to be available when the embedded object is right-clicked.
You can select which language to use in menus for the embedded object.
You can select which theme to use for the embedded object.
You can choose if the user can make selections in the embedded object, and which selection state to show in the embedded object.
You can select to use the current selections in the app.
You can select to show the selections bar above the sheet.
You can select if you want the user to be able to make selections in the embedded object. You also need to enable Allow interaction.
You can select to clear all selections made in the app when the object is rendered.
You can select to apply a bookmark and use the selections defined in the bookmark. Bookmarking selections
When the page containing the embedded object is rendered, the initial selection state is defined by the order of execution and your settings.
When you make selections in the embedded object, they will be replicated in the app. If you select Clear selections on reload, for example, and use the embedded object, selections are cleared in the app.
Enjoy it,
Arturo (@arturoqv)
Data is used across all different types of organisations in every sector from banking to retail and healthcare to manufacturing. And as we all know, data is very valuable. When insights are understood and interpreted correctly, they can have a huge impact in cutting costs and creating efficiencies. But it’s not all about profit margins and revenue. Data can also be used to help solve some of the world’s most pressing issues.
Qlik.org is the Corporate Responsibility arm of Qlik and provides plenty of examples of how we can lead with data to create a more sustainable world. You will find examples of sustainability initiatives from water security to global health strengthening, and the role that data plays to tackle these challenges.
Recently, Qlik.org ran a hackathon with the challenge of building an application to help the UN plan their air travel more responsibly and to reduce emissions. The “No planet B Challenge” blog post gives the full story. The winning application is due to be launched at the Global Climate Action Summit in September and will also be made available to the public.
If you are a student or academic and want to analyse your own data to see how you can drive positive change at the individual or community level, the Qlik Academic Program can help you to do this. You will receive free access to Qlik software and training resources which could be used to determine how you can reduce your CO2 footprint, or electricity usage or meat consumption...Even at the micro level, data can help us to all do our bit to contribute to a more sustainable world. To sign up for the program today visit: qlik.com/academicprogram.
Florence Nightingale may not be the first person who springs to mind when you think of big data, but in fact it's not such a strange pairing as you may initially think.
Did you know that before Florence became a nurse she trained as a statistician? And prior to the Crimean War she became a successful hospital manager. During that war she combined her nursing and statistics to reduce death rates in military hospitals from 42% to just 2%, and used infographics to ensure that politicians couldn't ignore the figures.
This short BBC ideas video directed by James Quinn encourages us to think about what Florence might think of the vast volumes of data available to us today, and the opportunities that we have to use that data to make the world a better place.
Our Qlik Academic Program aims to give University students the ability to read, work with, analyse and argue with data to bring about positive change, regardless of their discipline or area of interest. And the program is also open to University academics who want to bring this teaching into their classrooms. To find out more or to sign up visit: qlik.com/academicprogram, and maybe you could be the next Florence Nightingale!