Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Product Innovation
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
Support Updates
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
Qlik Academic Program
This blog was created for professors and students using Qlik within academia.
Community News
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
Qlik Digest
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
Qlik Learning
The Qlik Learning blog offers information about the latest updates to our courses and programs, as well as insights from the Qlik Learning team.
Recent Blog Posts
-
The Table Viewer
The table viewer is a gem.I use it for many things: to get an overview; to debug what I have done in the script; to check that all tables are linked; to check that I don’t have any unwanted synthetic keys; to preview data. I can hardly remember what I did before QlikView had it¹.Just hit <ctrl>-T and you will see it.I move around the tables until the structure corresponds to the picture I have in my head of the data. I tell new users developing a... Show MoreThe table viewer is a gem.
I use it for many things: to get an overview; to debug what I have done in the script; to check that all tables are linked; to check that I don’t have any unwanted synthetic keys; to preview data. I can hardly remember what I did before QlikView had it¹.
Just hit <ctrl>-T and you will see it.
I move around the tables until the structure corresponds to the picture I have in my head of the data. I tell new users developing applications to draw the wanted data model on a piece of paper so they know what the goal is. If they can't draw it on a piece of paper, they need to sit down and think. Or play around with data in QlikView until they can draw the data model. The structure seen in the table viewer then becomes an acknowledgement that the data model is correctly implemented. Or a warning that it isn't.
There are two modes of the table viewer: The Internal table view and the Source table view. The only difference is how the synthetic keys are displayed. During the script development, I always use the source table view, since it shows me exactly what I have done in the script.
If you hover above the table headers, you can see the number of records and number of fields. If you hover above an individual field, you will get the data for this specific field: Whether it is a key, the information density, the subset ratio and – if applicable – the tags.
Many, when they see the table viewer, start thinking about a graphical tool to define which source data to load. But this is not what the table viewer is – it is a viewer only. Unfortunately or luckily, whichever way you look at it…
“Unfortunately” since a graphical tool no doubt would help many people, especially in the initial phase, when they want to load data quickly just to get a look at it. “Luckily”, since you never will get the same versatility using a graphical tool as you will with a script editor. For instance, almost all advanced data transformations I have shown in previous blog posts (e.g. How to populate a sparsely populated field) would be almost impossible to describe with a graphical tool. They would at least be very complex to depict, and most likely less user-friendly than having to write the actual code.
So, if we get a graphical script generator some day in the future, it should be some kind of hybrid where scripting still is allowed and we have the best of both worlds.
Until then, I will happily use the table viewer as it is: As the best available tool to get an overview of the data model. And as one of the best debugging tools in the application development process.
And that is not bad.
¹In fact, I do remember what we did before the table viewer existed: We used a cross table (a pivot table) with the system fields $Field and $Table as dimensions and Only([$Field]) as expression. It worked, but it did not give the same overview.
-
Card style web component w/ fullscreen capability for mashups
Recently I've been working on building a mashup template that will work in the dev-hub that will have a few more advanced features than many of the available dev-hub templates. One of these features that I thought was important was a card container for Qlik Sense objects that has fullscreen capability built in. I'd like to share that with you today. Here's an example of a really simple mashup with just the selection toolbar, and 2 Qlik Sense obje... Show MoreRecently I've been working on building a mashup template that will work in the dev-hub that will have a few more advanced features than many of the available dev-hub templates. One of these features that I thought was important was a card container for Qlik Sense objects that has fullscreen capability built in. I'd like to share that with you today.
Here's an example of a really simple mashup with just the selection toolbar, and 2 Qlik Sense objects that use the qliksense-card web component I've built - Qlik Sense Mashup.
To use the qliksense-card web component yourself, you have a couple of options. You can either install the dev-hub template and create a new mashup from the dev-hub using the template, or you can just grab the necessary files and load them into your project.
Installing dev-hub template
You can download the dev-hub template here - GitHub - qliksense-card-template. After downloading, install the template as you would install any extension in Qlik Sense. After the template is installed, you can go to the dev-hub, create a new mashup, and select "Card template" from the dropdown list of templates.
The template is really kind of bare. There's not much going on besides the qliksense-card web component and a bit of bootstrap, but it's a good way to check out how the qliksense-card web component works.
Including the files in your own project
You don't have to use the dev-hub template to make use of the qliksense-card web component. What you will need is the qliksense-card.html file and the webcomponents-lite.min.js file. The easiest way to include them is to use the RawGit CDN, example below.
<script src="https://cdn.rawgit.com/download/polymer-cdn/1.7.0.2/lib/webcomponentsjs/webcomponents-lite.min.js"></script>
<link rel="import" href="https://cdn.rawgit.com/fkabinoff/qliksense-card-template/master/qliksense-card.html">
Using the qliksense-card component
After you're all setup, whether you've generated a new project using the dev-hub template, or included the necessary files in your own project, using the qliksense-card web component is easy. All you want to do is wrap your Qlik Sense object container with the qliksense-card tag, and set the height of the Qlik Sense object with the content-height attribute of the qliksense-card tag. You'll also want to set the width and height of your Qlik Sense object container to 100%. If you've generated a project using the template, this stuff has already been done, and you can check it out and just reuse as you'd like. If you've just included the necessary files in your own project, you can still check out the template files to see how it's done. Generally, it'll look something like below
<qliksense-card content-height="300px">
<div class="qvobject" id="QV01"></div>
</qliksense-card>
-
Qlik GeoAnalytics: An example of binning
A few weeks ago, we got into a new project to create an interactive piece with the Canadian media, National Post. The goal was to illustrate the donations candidates of the Conservative Leadership Race received from the start of the race through March 2017. Qlik Sense was integrated with Qlik GeoAnalytics to visualize where the donations were coming from and which candidates received the most donations in each area. The map below was one of our ... Show MoreA few weeks ago, we got into a new project to create an interactive piece with the Canadian media, National Post. The goal was to illustrate the donations candidates of the Conservative Leadership Race received from the start of the race through March 2017. Qlik Sense was integrated with Qlik GeoAnalytics to visualize where the donations were coming from and which candidates received the most donations in each area.
The map below was one of our first tries, we decided to use color to illustrate the top candidate by amount collected, and by postal code.
Problem with this approach appeared obvious at a first glance, postal codes areas have an insane size variance, regions such as the northern and barely populated province of Nunavut extents thousands of square miles in just one postal code while postal areas in urban zones, such as in Toronto, span a few city blocks and are hidden in the map.
So, how to make Nunavut and Toronto visible and comparable?
We decided to apply a binning operation to our data to solve most of the issues described. Qlik GeoAnalytics has a wizard that lets you chose operation, making the process seamless. The result is a new table containing squares (or hexagons) geo-polygons.
In this new map version, readers can compare areas easily without the distortion introduced by the different postal code sizes, letting us to see what’s going on in Toronto and in Nunavut at the same time.
We've added some extra cool features to the resulting Qlik Mashup. I recommend you to visit it and explore it at http://news.nationalpost.com/news/qlik
Enjoy,
AMZ
-
Redefining the Week Start
Six days thou shalt work, but on the seventh day thou shalt rest. [Exodus 34:21]The idea that you should rest on the seventh day is a central concept in both Christianity and Judaism. But which weekday is the seventh day of the week? And which day is the first?The old texts of the Abrahamic religions clearly consider the Sabbath – Saturday – as the seventh day of the week... Show MoreSix days thou shalt work, but on the seventh day thou shalt rest.
[Exodus 34:21]
The idea that you should rest on the seventh day is a central concept in both Christianity and Judaism. But which weekday is the seventh day of the week? And which day is the first?
The old texts of the Abrahamic religions clearly consider the Sabbath – Saturday – as the seventh day of the week. This day is also still today the resting day for Jews around the world. The same texts also describe how Adam was created on the sixth day, which is one of the reasons why Friday is the day of congregation and prayers for Muslims.
Hence, these two religions agree on the numbering of week days: Friday is the sixth day of the week and Saturday is the seventh.
However, in the rest of the world, the situation is more confusing: Although Sunday is observed as resting day in most countries, there is a disagreement on whether Sunday is the first or the seventh day of the week. In North America, Sunday is the first day of the week, but in many European countries it is the last day of the week. According to the International Organization for Standardization (ISO 8601), the week starts on a Monday, and Sunday is thus the seventh and last day of the week.
How weekdays are ordered makes a difference in all Business Intelligence applications, most notably in how list boxes and charts are sorted. Note the order of the week days in the list boxes below. In the left one, Sunday is on top of the list and in the right one it is Monday.
This difference can also be seen in calendar displays, used in many types of software and on many sites in the web. Again, note the order of the week days.
QlikView uses ISO 8601 to define the week days and the week start. WeekDay() returns the name of the week day (as defined in the variable DayNames) and a number from 0 to 6; Monday being day number 0. WeekStart() returns the date of the Monday immediately before the date supplied as parameter.
If you want redefine this, e.g. if you want QlikView to show Sunday as the first day of the week – here’s how you do it:
Start by creating a variable that defines the beginning of the week:
Set vCal_FD = 6; // First Day of the week (0=Mon, 1=Tue, ... , 6=Sun)
The WeekStart() function has an offset parameter, and if you use your variable here, you can redefine how the function works and get the week start on the correct day:
WeekStart( Date, 0, $(vCal_FD) ) as WeekStart
The WeekDay() function, however, cannot take any offset parameter, so you need to define the week day using the Dual() function:
Dual( WeekDay( Date ), Mod( WeekDay( Date - $(vCal_FD) ), 7 ) +1 ) as WeekDay
Using these two expressions in your Master Calendar instead of the standard function calls, you can redefine the week start to any of the week days.
Further reading related to this topic:
-
Ask Mike - What is Qlik Market?
Hey guys, I'm trying something new this time around, a talking-head video - or perhaps better known as video blogging.In this video I answer community members' and twitter followers' questions. Recently I was asked to explain what Qlik Market was and who should use it. Watch this brief video to learn more.Visit Qlik Market today: http://market.qlik.com/Partners: Partner Portal | Over 1,700 partners around the world - must obtain access to Qlik Ma... Show MoreHey guys, I'm trying something new this time around, a talking-head video - or perhaps better known as video blogging.
In this video I answer community members' and twitter followers' questions. Recently I was asked to explain what Qlik Market was and who should use it. Watch this brief video to learn more.
- Visit Qlik Market today: http://market.qlik.com/
- Partners: Partner Portal | Over 1,700 partners around the world
- must obtain access to Qlik Market to submit your solution
If you have a specific question (that's right - I said specific question) about Qlik or Qlik Products and you want me to answer it, hit me up on Twitter https://twitter.com/mtarallo or tag me in a Qlik Community discussion. Now note I can't promise to answer every question, but hopefully our valued members and Qlikies can jump in too. If your specific question benefits others it may be featured in my next video blog. Enjoy!
Next on deck: How you can get your product ideas heard and considered.
NOTE: To increase resolution or size of the video, select the YouTube logo at the bottom right of the player. You will be brought directly to YouTube where you can increase the resolution and size of the player window. Look for the 'settings' gears icon in the lower right of the player once at YouTube.
Can't see the video?
Download the .mp4 and watch from your computer or mobile device.
-
Push the Boundaries of Analytics - Qlik Sense Bot (video)
Good Tuesday Qlik Community! Today I have a fun and entertaining way to showcase the power of the Qlik Sense platform, its APIs and the art of the possible. But first, let me give you some background. In March, Qlik participated in the Gartner BI Bake Off (direct highlights here) - and for the 'innovation' portion of the presentation, my colleague Josh Good demonstrated a neat concept, showing what is possible with the Qlik platform and it's robu... Show More
Good Tuesday Qlik Community! Today I have a fun and entertaining way to showcase the power of the Qlik Sense platform, its APIs and the art of the possible. But first, let me give you some background. In March, Qlik participated in the Gartner BI Bake Off (direct highlights here) - and for the 'innovation' portion of the presentation, my colleague Josh Good demonstrated a neat concept, showing what is possible with the Qlik platform and it's robust set of APIs - a Qlik Sense Bot - developed by my colleague Juan Gerado Cabeza. Since then we are getting numerous requests to see and learn more about what was shown on that day, so I have create this brief video to share some of its insights.
What is a Bot you may ask?You already know some popular bots – Siri, Cortana, Alexa and of course Google. These guys are programs designed to perform tasks, such as setting an alarm, telling you the weather, searching online or even ordering a pizza. So why not have a bot tell you who your top sales people are, alert you when profit margin reaches 20% – or - even have it send you charts and reports directly to your device? The possibilities are endless. Juan as done just that, creating an analytical assistant - that in actuality turns Qlik data visualization into conversational analytics.
Now understand the Qlik Sense Bot - IS NOT a product provided by Qlik, but rather a neat concept that demonstrates the art of the possible when using the Qlik platform and its APIs. Now - neatness, coolness and Qlik platform superiority aside, what I like the most about this innovation is that it provides many real world applications. Bots can be used by anyone, anywhere, on any device and at anytime – scheduling automated tasks and providing access to information when and where you need it – reducing complexities, and increasing availability of insight by simply having a conversation. So in my opinion I do see this as a viable product offering, but you never know. Watch this brief video to learn more about this awesome concept. If you want even more information about this superior innovation, please contact us at qlik.com, or you can reach out to us on Twitter or on the Qlik Community.
Have a great day!
Regards,
Michael Tarallo (@mtarallo) | Twitter
Pushing the Boundaries of Analytics - Qlik Sense Bot
We want to hear from you. Please leave your comments and questions in the comments section below.
NOTE: To increase resolution or size of the video, select the YouTube logo at the bottom right of the player. You will be brought directly to YouTube where you can increase the resolution and size of the player window. Look for the 'settings' gears icon in the lower right of the player once at YouTube.
NOTE: Can't see the video? Download the .mp4 to play on your machine or mobile device.
-
Context Is Next
Why Contextual Learning Is The Best New Way to Learn Software?"The way that we learn as adults has evolved over time. As technology continues to evolve, we learn more about how our brains process information. We are going through another inflection point in leaning towards a model of learning based off contexts and relationships."From one-to-one to many-to-manyLearning started as apprenticeships where students learned on the job with a master tea... Show MoreWhy Contextual Learning Is The Best New Way to Learn Software?
"The way that we learn as adults has evolved over time. As technology continues to evolve, we learn more about how our brains process information. We are going through another inflection point in leaning towards a model of learning based off contexts and relationships."
From one-to-one to many-to-many
Learning started as apprenticeships where students learned on the job with a master teacher. This worked well, but since this was a one-to-one relationship, it did not scale well. Then, the model evolved to a one-to-many, teacher-centric approach where one teacher trained many students at once. This then evolved into a learner-centric approach where learners took control of their own learning, including self-directed learning approaches and performance support. Some of the benefits of the learner-centric approach are that students are able to learn what they want, when they want to learn it. In that way, teachers didn't have to teach concepts which may not be relevant to all, or which may go at different levels or speeds which are not ideal for each student. However, what was initially lacking from the learner-centric approach is context and social relationships, a many-to-many approach to learning.
To read the full article written by Kevin Hanegan (VP Knowledge & Learning) visit Context Is Next | Qlik Blog
-
Engine API and qSocks - Connecting and getting a list of available apps
In an earlier post, i have demonstrated how to connect to our app using Mashup API and displaying the objects on our webpage without much coding (https://community.qlik.com/blogs/qlikviewdesignblog/2015/05/22/creating-a-webpage-based-on-the-qlik-sense-desktop-mashup-api).In one of my projects, I had to create custom charts one of which is to compare two golf players versus one measure. That means that I had to have a chart with 2 lines, one for... Show MoreIn an earlier post, i have demonstrated how to connect to our app using Mashup API and displaying the objects on our webpage without much coding (https://community.qlik.com/blogs/qlikviewdesignblog/2015/05/22/creating-a-webpage-based-on-the-qlik-sense-desktop-mashup-api).
In one of my projects, I had to create custom charts one of which is to compare two golf players versus one measure. That means that I had to have a chart with 2 lines, one for each player, compared hole by hole This kind of visualization does not exist yet in Qlik Sense so I decided to build everything with qSocks and the Engine API.
I think this is the best solution for custom projects like this, since the Engine API is faster and it is loading only raw data.
qSocks is a wrapper intended to make our life easier on communicating with the Engine.(QSocks - Engine API wrapper).
In this first tutorial, I will show you how to connect to your Qlik Sense server and get a list of the available apps with qSocks.
- In your html header, add qSocks that you downloaded from the link above and your js file.
<script src="js/qsocks.bundle.js"></script>
<script src="js/index.js"></script>
- In your index.js, or however you have named your js file, add the connection configuration.
var config = {
host: 'yourserver.com',
isSecure: true
};
- Establish a connection with the server based on that configuration.
qsocks.Connect(config).then(function(global) {
- Get the list of all available apps on the server.
global.getDocList().then(function(docList) {
- If you want to view the available apps on your console, do a forEach loop on that docList.
docList.forEach(function(doc) {
- Here is what the console will output if you do "console.log(doc)"
Here is the full code:
var config = {
host: 'yourserver.com',
isSecure: true
};
function connect() {
qsocks.Connect(config).then(function(global) {
global.getDocList().then(function(docList) {
docList.forEach(function(doc) {
console.log(doc.qDocId)
});
});
});
};
connect();
In the next tutorial I will show you how to use the app id (qDocId) to connect to the app and get the available objects to display
-
November 2017 Features and Amazon Redshift Now Available in Qlik Sense Cloud
(Originally posted on 11/29 on the Qlik Sense Cloud blog, so in case you missed the updates, read on!)Qlik Sense November 2017 ReleaseOur Qlik Sense November 2017 release features are available in Qlik Sense Cloud. Qlik Sense Cloud Basic and Qlik Sense Cloud Business users now have access to the newest data prep, visualization, and usability improvements, including:Improvements to existing chart types:Tables – scroll sidewaysBox Plot – color by e... Show More(Originally posted on 11/29 on the Qlik Sense Cloud blog, so in case you missed the updates, read on!)
Qlik Sense November 2017 Release
Our Qlik Sense November 2017 release features are available in Qlik Sense Cloud. Qlik Sense Cloud Basic and Qlik Sense Cloud Business users now have access to the newest data prep, visualization, and usability improvements, including:
- Improvements to existing chart types:
- Tables – scroll sideways
- Box Plot – color by expression
- Distribution Plot – color by expression, control bubble size, and add jitter (to keep dots from overlapping)
- Combo Chart – display value labels
- Ongoing Visual Data Prep Enhancements
- UI based in-line data table
- Data Transformation Lineage
- Refresh and add data available from analysis edit mode
- Dynamic Sheet Names – utilize an expression in the name of a sheet
- Navigation Improvements using Keyboard – use the tab key to move around the screen
Mike Tarallo shows off all of these new features in his recent design blog post.
New Connectivity – Amazon Redshift
We’re excited to announce that Amazon Redshift is the newest addition to our expanding list of connectivity options for Qlik Sense Cloud Business users. Now you can easily connect to data stored in your Amazon Redshift database by creating a new connection in Add Data or the Data Load Editor. Visit our help section to learn more about how to set up the connection.
The full list of connectivity options in Qlik Sense Cloud Business now includes:
- General Connectivity: upload or attach files; connect to web files; REST, Microsoft SQL Server, and Amazon Redshift
- CRM Connectivity: Salesforce, SugarCRM, and Microsoft Dynamics
- Other Cloud applications: Bitly, Facebook, Google Analytics, Google Adwords, MailChimp, Slack, SurveyMonkey, Twitter, and YouTube
Coming Soon
We’re close to releasing our Dropbox connector for Qlik Sense Cloud Business and excited to add another flexible connectivity option for users. For a preview of how to use the Dropbox connector, check out Mike Tarallo’s recent design blog and video below about how to refresh file-based data stored in Dropbox.
More Qlik Sense Cloud highlights:
- On-Demand Webinar: Cloud BI Strategy: Do’s, Don’ts, and Gotchas
Hear about the latest trends in cloud BI! Cindi Howson of featured analyst firm Gartner explains all the factors you need to know about cloud BI. Plus, Anthony Deighton, Qlik's Chief Technology Officer and Senior Vice President, Products, shares the latest on Qlik's unique hybrid cloud solution.
- Live Qlik Sense Cloud Webinars: attend a live, interactive webinar with the team to get your Qlik Sense Cloud questions answered and learn more.
- Improvements to existing chart types:
-
PRESS RELEASE! Qlik Expands Academic Program with Mission to Bridge the Data Lit...
The Academic Program is excited to announce that we released a global press release today that features information about all of the programs new resources and feedback from students and professors who have successfully shared in the benefit of becoming members! Sneak Peek...“By participating in the Qlik Academic Program, these students are not only making themselves more marketable, but they’re prepared to stand out in today’s competitive workfo... Show More
The Academic Program is excited to announce that we released a global press release today that features information about all of the programs new resources and feedback from students and professors who have successfully shared in the benefit of becoming members!Sneak Peek...
“By participating in the Qlik Academic Program, these students are not only making themselves more marketable, but they’re prepared to stand out in today’s competitive workforce and set the new standard as the next generation of data literate business leaders driving the analytics economy.”
For the full article visit
https://www.qlik.com/us/company/press-room/press-releases/0103-qlik-expands-academic-program
We encourage you to share this article through social media!
-
Looking to be Data Literate? Begin with Curiosity!
Data literacy is everywhere, but don’t know where to begin? Start with a curious mind....It has been said that curiosity killed the cat, well, in the case of data and analytics, curiosity brings success.In the world of data and analytics, we are hearing a lot more about data literacy, and the reality is, data literacy is vitally important to companies and their cultures to succeed, but most people are asking: where do we begin? There are many ste... Show MoreData literacy is everywhere, but don’t know where to begin? Start with a curious mind....
It has been said that curiosity killed the cat, well, in the case of data and analytics, curiosity brings success.
In the world of data and analytics, we are hearing a lot more about data literacy, and the reality is, data literacy is vitally important to companies and their cultures to succeed, but most people are asking: where do we begin? There are many steps and things that can be done to build the right data literate culture, infusing success in data literacy throughout an organization, but there is a certain mindset that needs to permeate throughout the organization: curiosity. What does it mean to be curious within analytics? Why is curiosity such a vital mindset to have within the world of data literacy?
Did you know the Academic Program offers a Data Analytics course that delves into Data Literacy?! Professors and students can review the course materials by visiting the Course: Academic Program Learning Resources.
NOTE: If you do not have access you can reapply to the program by visiting https://www.qlik.com/us/company/academic-program
To read the full article written by Jordan Marrow (Qlik Global Head of Data Literacy) visit Looking to be Data Literate? Begin with Curiosity! | Qlik Blog
-
Year in review. 2017 Top Blog Posts
It's time for the end-of-the-year in review post, it's time for the cream of the crop.During 2017 six main authors and a respectable number of guest bloggers posted a total number of 85 articles (plus this one).We wrote 39,822 words (7,819 distinct words), that’s 15% more than the number of words we wrote previous year. We wrote the word “Qlik” 566 times, an absolute record. You contributed 695 times to the success of this blog in the comments se... Show MoreIt's time for the end-of-the-year in review post, it's time for the cream of the crop.
During 2017 six main authors and a respectable number of guest bloggers posted a total number of 85 articles (plus this one).
We wrote 39,822 words (7,819 distinct words), that’s 15% more than the number of words we wrote previous year. We wrote the word “Qlik” 566 times, an absolute record. You contributed 695 times to the success of this blog in the comments section, we truly appreciate your feedback and comments!
Most popular posts in 2017
Most read/visited posts
Don't be the last one to read it!
- Qlik Sense September 2017 - What's New
- Quotes in Set Analysis
- Push the Boundaries of Analytics - Qlik Sense Bot (video)
- Take a look at Qlik Sense June 2017
- Introducing DAR mashup template
Most commented posts of the year
Everyone is buzzing
- Quotes in Set Analysis
- Introducing Qlik Sense 3.2
- Take a look at Qlik Sense June 2017
- Qlik Sense September 2017 - What's New
- Push the Boundaries of Analytics - Qlik Sense Bot (video)
The underdogs 2017
They worth a second read.
- Qlik Sense WordPress Plugin
The world most popular CMS and the most powerful Analytics platform combined? it seems like a perfect match. This blog post is capturing a lot of comments, check it out and join the conversation. - Rank Function
Some of the old Qlik functions still have secrets, check this post to learn what you are missing from the Rank function. - Intro to Qlik Open Source Software
It feels great to contribute to the Open Software community, read what Qlik has to offer! - Salesforce and CIO dashboard mashups available to the public
You can use these examples as templates or just dissect them into pieces to learn more about Qlik APIs and how to build impacting data sites.
I wish you an enjoyable New Year countdown!
Arturo (@arturoqv)
-
Qlik Help!
Did you know about Qlik | Help ?! The Help page is dedicated to ensure you are equipped with all the resources and knowledge necessary to be successful with Qlik Sense or any other Qlik product you might be working with!After using the free training from the Qlik Continuous Classroom, the Help page is a great resources which provides videos, tutorials, guides, demos, and much more! Plus its available in multiple languages!Save this link Qlik |... Show More
Did you know about Qlik | Help ?! The Help page is dedicated to ensure you are equipped with all the resources and knowledge necessary to be successful with Qlik Sense or any other Qlik product you might be working with!After using the free training from the Qlik Continuous Classroom, the Help page is a great resources which provides videos, tutorials, guides, demos, and much more! Plus its available in multiple languages!
Save this link Qlik | Help and remember to take advantage of the Help site when in need!
-
Mashup Editor - Search as you type box
In my previous posts I have showed how to use bootstrap's drop-down menus with the Capabilities API. In this tutorial I will show you how to use jQuery's UI to get results as you type like thisFrom the dev-hub (http://localhost:4848/dev-hub/) click on "Create New", to create a new mashup. Give it a name and select as template the "Grid mashup template"Select the "Helpdesk Management.qvf" for your app.On the right hand side, click on "Create a lis... Show MoreIn my previous posts I have showed how to use bootstrap's drop-down menus with the Capabilities API. In this tutorial I will show you how to use jQuery's UI to get results as you type like this
- From the dev-hub (http://localhost:4848/dev-hub/) click on "Create New", to create a new mashup. Give it a name and select as template the "Grid mashup template"
- Select the "Helpdesk Management.qvf" for your app.
- On the right hand side, click on "Create a list". This will be the results that we would like to search on.
- From the left hand side click and drag the "case details" table onto the preview panel
- Click on "Fields" and select "Case Owner".
- Under "Rows" put 100 since we do not need any more for this tutorial, and give a name to your callback function. I usually name mine as "refactorData" because I restructure all of the data in a more accessible format. Once you hit create, you will see that the code for the list was added as well as the refactorData in line 108.
- In our html's headers, after bootstrap css and right before requirejs, add the jquery ui css and js
<link rel="stylesheet" href="https://community.qlik.com//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="https://code.jquery.com/jquery-2.1.4.min.js"></script>
<script src="https://code.jquery.com/ui/1.11.4/jquery-ui.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
- Let's add the code into our callback function
function refactorData(reply, app){
var data = [];
for (var i = 0; i < reply.qListObject.qDataPages[0].qMatrix.length; i++) {
data.push(reply.qListObject.qDataPages[0].qMatrix[0].qText);
}
$("#search").autocomplete({
source: data
});
};
- In our "function AppUi ( app ) {" add the code below that will make the actual selection in our app
$( "#searchBtn" ).on( 'click', function () {
app.field('Case Owner').selectValues([$('#search').val()], false, false);
});
- Now Let's add the text box in our html page. Replace the "<div class="col-sm-4 qvplaceholder" id="QV01">" with this one
<div class="col-sm-4 qvplaceholder" id="QV01">
<div class="input-group input-group-sm">
<input type="text" class="form-control" placeholder="Type in the Case Owner" aria-describedby="basic-addon1" id="search" name="search">
<span class="input-group-btn">
<button class="btn btn-default" type="button" id="searchBtn"><span class="glyphicon glyphicon-search" aria-hidden="true"></span> Search</button>
</span>
</div>
</div>
And that's it. The final should look like this
YV
-
We want you - Apply to be a 2018 Qlik Luminary!
Hi Guys, we are almost at the finish line for 2017! So roll up your sleeves and get ready to show off that Qlik creativity and passion as we are ready to start accepting applications for our 2018 Qlik Luminary program. Here to tell you more is our Global Customer Communications Manager, Viktoria Lindback. Viktoria Lindback has had many roles during her 5-year tenure at Qlik. Today, she runs global customer programs including the https://www.qlik.... Show More
Hi Guys, we are almost at the finish line for 2017! So roll up your sleeves and get ready to show off that Qlik creativity and passion as we are ready to start accepting applications for our 2018 Qlik Luminary program. Here to tell you more is our Global Customer Communications Manager, Viktoria Lindback.
Viktoria Lindback has had many roles during her 5-year tenure at Qlik. Today, she runs global customer programs including the https://www.qlik.com/us/solutions/customers/qlik-luminaries which means she gets to spend the majority of her time interacting with the most enthusiastic Qlik users around the world.
If you haven’t heard of the Qlik Luminary Program yet, this is a great time to get educated about it because we’re accepting applications to the 2018 Qlik Luminary Program as we speak!
Click here to see our awesome Qlik Luminary Class of 2017
Every year, we roll out the green carpet to a remarkable group of people who all receive the “Qlik Luminary” designation. With deep drive, passion and expertise, Qlik Luminaries are constantly pushing the envelope, finding new and innovative ways to use, deploy and talk about Qlik solutions. Some of them are BI thought leaders; others are recognized industry visionaries, business leaders, or masterful developers. But what they all have in common is a passion for innovating with Qlik and sharing their expertise with others in a global arena. You will catch them speaking at events, running Qlik Dev Group, writing blog posts, contributing to case studies, and participating in Qlik Community and other social networks. A great place to follow their work is #QlikLuminary on Twitter.
Here are some of the characteristics of a Qlik Luminary:
- Passionate about Qlik and widely recognized as a BI innovator and expert in his or her field
- Active and consistently helpful on Qlik Community
- Active on online forums, industry social networks, and/or organizational or personal blog
- Willing to share best practices and knowledge at industry events, forums, in the press, and with industry analysts
- Prolific content creator who creates or contributes to blogs, white papers, reviews, articles, videos, etc.
There are also plenty of benefits to being a Qlik Luminary. They enjoy free access to state of the art Qlik training, custom merchandise, exclusive engagements with R&D, Product Management, and Support teams, membership in a private Qlik Community group, NDA briefings with Qlik product executives, and VIP treatment at Qonnections.
We are accepting applications for the 2018 cohort until December 31st here: https://www.qlik.com/us/solutions/customers/qlik-luminaries
Don't miss your chance to join a group of the sharpest brains and most skilled users in the BI industry!Kinds Regards,
Viktoria (@VLindback) | Twitter
Global Communications Manager
Qlik
-
When do you post to Facebook? (revisited)
I posted back in May about creating an app that allows a user to authenticate with Facebook, grabs the user's post data, generates a load script, and creates a Qlik Sense session app with enigma.js (When do you post to Facebook?). At the time, I still had to overcome a few hurdles to put it up live so you could check it out yourself. Since then, it's also become possible to create a Qlik Sense session app with the Capability APIs so that you can... Show MoreI posted back in May about creating an app that allows a user to authenticate with Facebook, grabs the user's post data, generates a load script, and creates a Qlik Sense session app with enigma.js (When do you post to Facebook?). At the time, I still had to overcome a few hurdles to put it up live so you could check it out yourself. Since then, it's also become possible to create a Qlik Sense session app with the Capability APIs so that you can use the Visualization API with your on-the-fly Qlik Sense session apps, which I posted about in September (Creating apps on the fly).
The demo is now up live, and there's two versions of it, one using enigma.js, and one using the Capability APIs. They're pretty minimal when it comes to design yet, I plan on building them out a bit more still, but it's cool to just see this all working, authenticating a user with Facebook, grabbing their data, generating a load script, creating a Qlik Sense session app, and visualizing the data. It's easy to see how something like this could be applied to a business use case where users may have very user-specific data. Check the demos out below!
Capability APIs version - Qlik Sense Session App Demo - Capability APIs
enigma.js version - Qlik Sense Session App Demo - enigma.js
-
Data Science: The New Art
Data Science is a new and growing field, but what exactly is it? In this digital world of data, the Internet of Things, and more, there is one term which seems to come up everywhere: Data Science.Data Science has taken on a life of its own, bringing immense value to organizations when utilized correctly - but what does it mean? And how should organizations embrace it? I recently asked an industry thought leader and expert on this topic, Marie Cl... Show MoreData Science is a new and growing field, but what exactly is it?
In this digital world of data, the Internet of Things, and more, there is one term which seems to come up everywhere: Data Science.
Data Science has taken on a life of its own, bringing immense value to organizations when utilized correctly - but what does it mean? And how should organizations embrace it? I recently asked an industry thought leader and expert on this topic, Marie Clark of Ambient Intelligence, to help define and shed light on this curious world.
To read the full article written by Jordan Marrow (Qlik Global Head of Data Literacy) visit Data Science: The New Art | Qlik Blog
-
Thank you team for the New Qlik Help Site
Hello Qlik Community! In Tuesday's edition of the Design Blog I highlight some of the latest features found in our new Help Site - created with collaboration from our engineers, technical writers and our Product Content and Media team. We hope that the site's new layout and navigation features make it easier to find the information you need, when you need it.The New Qlik Help Site "Teamwork for results" -- this is one of Qlik's core values that m... Show More
Hello Qlik Community! In Tuesday's edition of the Design Blog I highlight some of the latest features found in our new Help Site - created with collaboration from our engineers, technical writers and our Product Content and Media team. We hope that the site's new layout and navigation features make it easier to find the information you need, when you need it.
The New Qlik Help Site
"Teamwork for results" -- this is one of Qlik's core values that many of us embrace when creating content that makes our community successful with the Qlik platform. However, few are aware of our unsung heroes that work behind the scenes to bring you this great content, delivered to the Qlik Help site as well as our Qlik Help YouTube channel. I'd like to take this moment to thank and recognize them on behalf of the Qlik Community.
There is a small army led by Renata Rieschel, Director Product Content and Media. Renata manages the development and maintenance of all the content, design and infrastructure of the Qlik Help site. Our technical writers and architects not only design and write the help documentation, but they are also tasked with writing video scripts and verifying content from a linguistic point of view for many of the structured help videos you will find on the Qlik Help Channel. We have even enlisted the appealing voice talents of our Collaboration Product Designer, Stephen Jasionowski and our Internal Communications Manager Helene Rudzinski to provide the voice-overs for many of the help channel videos created by our interaction designer Giuseppe Panella, including those from our new series Qlik Tuesday Tips and Tricks - found on YouTube.
With all this great content being created, both visual and text-based - how should it be hosted, what will the UI look like, how will people search, navigate and find what they need? That is where Magnus Franzen and Tobias Leander come in. They have built a framework and implemented a platform to host all this content and strive to improve the performance, accuracy and usability of it daily, providing you with the best user experience possible.
I'd also like to recognize our technical writers, interaction designers, web developers, architects and engineers in Product Content and Media whom all work together to bring you the best content in a timely and efficient manner.
Sara Garmark
Jim Siwila
Mary Newell
Chris Bushnell
Konstantinos Fioretos
Thomas Oxenby
Thomas Lewis
Daniel Chabot
Daniel Rignell
Filippo Guizzetti
Greg Ralston
Julia Beingessner
Kyle Weishaar
Mary Newell
Michelle Thomas
Ralf Narfeldt
Sarah Anderson
Ingemar Hansson
Karin Dahlgren
Swati Jha
Thank you Team!
Regards,
Michael Tarallo (@mtarallo) | Twitter
Senior Product Marketing Manager
QlikCan't see the video?
Download the .mp4 and watch from your computer or mobile device.
-
Barcelona Marathon, a mashup for discovery
Guided apps are probably the more common data viz pieces nowadays. Are strongly influenced by the traditional journalistic approach to a story and related with storytelling. The goal of guided apps is to walk the reader from point A to point Z.A well-constructed guided visualization is incredible powerful at proving a point, examples can be found almost daily at mass media websites. As a data professional, I love data stories but maybe because I’... Show MoreGuided apps are probably the more common data viz pieces nowadays. Are strongly influenced by the traditional journalistic approach to a story and related with storytelling. The goal of guided apps is to walk the reader from point A to point Z.
A well-constructed guided visualization is incredible powerful at proving a point, examples can be found almost daily at mass media websites. As a data professional, I love data stories but maybe because I’m such a data geek I usually never get completely satisfied by the visualizations used to emphasize the story. I almost always hungry for ways to explore the data or I simply miss one angle from the story to feel fulfilled.
On the other hand, the so-called Discovery apps are intended to let the user to manage the ride and rely on reader capacity to be able to interact and to understand the data they are looking at. Scenarios with simple and familiar data are generally more appropriate for discovery apps.
We recently got one of those great data sets for discovery, simple data and containing thousands of potential stories in it. Barcelona Marathon organization contacted us to create a piece to let runners (data users) to explore every corner of their data. They have been collecting runners’ data during the last decade, our part was just to put a nice wrap around it. We like to see it as a nice hybrid (more on the discovery side) of guided and discovery app.
We divided the mashup into three sections trying to help first time users to better get familiarized with the data. It’s just a visual separation of the data, each section belongs to the same data model, filters are global and every selection affect all the charts. For the clarity of it we reduced the use of set analysis as much as possible.
The app starts with race overview data, about participation and finishing times. The second section serves as demographic info, with three main characteristics to consider, age, sex and nationality. Finally, we reserved a little bit of complexity for the very last section, we called it Performance. As you can see in the picture below taken from the chart “Avg time by age” the sweet spot age for someone to run this marathon is 35 years old, in average people in that age get the best results.
You can check the mashup live at Barcelona Marathon page here or as a stand-alone version at Marató Barcelona.
Regards,
Arturo Munoz (@arturoqv)
-
NULL – The Invisible Nothing
NULL is not a value. It is a lack of value. It is a placeholder that marks nothingness. So, how does QlikView show the concept of nothing – when this is the relevant answer to the user’s click? To investigate this, I will use a hypothetical database with two tables: Customers and Orders. The Customers table is a list of customers, and the Orders table is a list of orders that these customers have placed. List boxes In the picture below, you h... Show MoreNULL is not a value. It is a lack of value. It is a placeholder that marks nothingness.
So, how does QlikView show the concept of nothing – when this is the relevant answer to the user’s click?
To investigate this, I will use a hypothetical database with two tables: Customers and Orders. The Customers table is a list of customers, and the Orders table is a list of orders that these customers have placed.
List boxes
In the picture below, you have a selection of two customers that haven’t placed any orders, i.e. they exist in the Customers table but there are no corresponding records in the Orders table. As a result, all values in the OrderID list box are gray.
In other words; for a list box, it is simple: NULL is not visible as an explicit list box entry. If all entries are marked as gray, then the empty set is the answer to the click, i.e. NULL is the answer.
If you have a list box where you have a visible entry that is blank; that you can click on; that can be selected, then it is not a NULL. NULLs are never visible in list boxes and can never be selected. Instead, you have an empty string or some kind of white space.
Table boxes
In a table box, as well as in all other places where a NULL can occur, e.g. labels, text boxes, buttons, etc., NULLs are displayed as dashes. In these places, NULL is visible but not selectable.
Chart dimensions
For a chart, it becomes more complicated. First of all, a NULL can occur either as a dimensional value or in the measure - the expression. These are two very different cases and should not be confused. Further, the two cases are managed in two different places in the chart properties.
With the above data, it would be reasonable to make a chart that shows sales per customer. If there are orders that are not attributed to any customer, then you will get a NULL in the dimension of the chart – a NULL which is displayed as a dash. Below you can see that order nr 10874 has no customer associated:
If you don’t want to show lines with NULLs in the dimension, you can suppress these on the Dimensions tab in the chart properties.
Chart measures
If your data is the other way around, i.e. you have customers that are not attributed to any orders, you will for these get NULLs in OrderID and Amount. However, the Sum() and Count() functions still return zero, which is correct, since Sum(NULL) is zero. Other aggregation functions such as Only() may return NULL, though, and this will be displayed as a dash.
If you don’t want to show lines with zeros or NULLs as expression value, you can suppress these on the Presentations tab in the chart properties.
So, the bottom line is that NULLs are sometimes visible, sometimes not. Sometimes they are displayed as dashes, and when aggregated, usually as zeros. But they are never selectable.
And with this, I hope that the mystery around NULLs is somewhat less of a mystery.
PS. In this blog post, I use “NULL” to denote both real NULLs and missing values. What the difference is? Read this (updated) white paper and find out. There you can also read about how to make NULLs both visible and selectable.
