Welcome to Part 3 in this series which will move us into learning about Qlik features, in their terms Module 2. Parts 1 and 2 of this series were focused on introduction to Qlik, Module 1 – see below for a recap on topics we have already covered.
The resources I am going to use for my self paced lessons are – 9x Qlik Features Videos (1hr) + Allowance for notes and follow along = 4hr of time. An overview of these 9 videos is below:
Video 1: Qlik Sense – Visual Exploration
This video is mostly targeted towards people viewing charts rather than people developing charts. It reiterates how you can edit a chart from the front end. If you are the author of the chart it shows you how to save these changes permanently also. A short description for a short video.
Covered: Customize apps from the front end, Permanently alter apps you author from the front end
Video 2: Qlik Sense – Using the Variables Interface
This is a really handy video for creating reusable content such as colours. It takes a much more in depth look at variables and how they might be used in the real world. The main focus is on using variables to control colours but there is also a bit about controlling titles in there too.
Topics: Creating Variables, Referencing Variables, Color Variables
Video 3: Qlik Sense – Developer Hub
A slightly longer video than we’re used to talking about a section of Qlik we have not used yet – the dev hub. It starts by introducing something called the Single-Configurator. This can be used to format and control external use of visualizations in iframes. Next is the Extension Editor. This is pretty self explanatory, it is the tool used for writing custom extensions with .qext .js and .png files. The most important part of this is the demonstration of resources used to create custom extensions. Next is the Mashup Editor. This is for building mashups. WTF is a mashup?! you might ask. A mashup is a method of integrating Qlik into your own application. Super handy! Towards the end of the video, we see something called the Engine API Explorer. It’s a very brief introduction to a complex tool. As a disclaimer, the version of Qlik used in the video is quite a different layout to mine which is currently the most recent release. The major difference is layout and the apps are available from a dropdown list instead of needing to copy paste the app id from the URL.
Topics: Single Configurator, Extension Editor, Writing Extensions, iFrames, Mashup Editor, Engine API Explorer
Video 4: Qlik Sense – Export to PowerPoint
Despite having a built in story telling tool, Qlik also allows you to export your discoveries to export. This is a handy tool for those working in restricted environments with predefined tools and formats.
Topics: Exporting to PowerPoint
Video 5: Qlik Sense – Attach Data Files (User Data Upload)
This video covers attaching data and images to your Qlik application. This means files and data will be exported and migrated along with the app. 50MB of storage is provided in the version used in the video, but this may change.
Topics: Data Upload, Image Upload, Attach Data and Images to an App
Video 6: Qlik Sense – Bundle Images with your Apps
Another iteration of the previous video but specifically looking at images.
Topics: Attach images to Apps
Video 7: Qlik Sense – Using Smart Data Compression
This is more something to be aware of than something to learn. It’s a video that covers what happens to a scatter-plot when there are more than 1000 data points.
Topics: Compress large data groups into a heat-map on a scatter-plot
Video 8: Qlik Sense – Using Qlik DataMarket
Two videos covering Qlik Data market. The first one is more of a sales pitch but it’s short so you may as well watch it. The second is a video to bare in mind when you need a great set of data, but can’t be bothered sifting through swaths of open source garbage online.
Topics: Source data from the Qlik DataMarket
So that’s the end of the second part. We have covered a fair bit of ground again, so it’s time for another sanity check. What have we covered?
- Customize apps from the front end (video 1)
- Permanently alter apps you author from the front end (video 1)
- Creating Variables (video 2)
- Referencing Variables (video 2)
- Color Variables (video 2)
- Single Configurator (video 3)
- Extension Editor (video 3)
- Writing Extensions (video 3)
- iFrames, Mashup Editor, Engine API Explorer (video 3)
- Exporting to PowerPoint (video 4)
- Data Upload, Image Upload, Attach Data an App (video 5)
- Attach images to Apps (video 5, 6)
- Compress large data groups into a heat-map on a scatter-plot (video 7)
- Source data from the Qlik DataMarket (video 8, 9)
If you’ve found this helpful, part 4 will be published next week, here is a reminder of what we have learned so far:
- Know the difference between Dimensions and Measures (resource 1)
- Know what each of the menus to the left of the edit screen do (video 1)
- Add data to our Apps (video 1, 3)
- Creating Apps, Sheets and Visualisations (video 1, 3, 5)
- Bucketing data (video 2, 4)
- Create calculated fields (video 2, 4)
- Simple edit data before load (video 3, 4)
- Style our Apps. Title, logo, name, colour etc. (video 4)
- Add alternative Measures and Dimensions (video 4)
- Form data associations (video 4)
- Create reference lines (video 4)
- Search visualizations (video 5)
- Convert Graphs (Video 5)
- Create Master Items (video 5)
- Style our visualizations layout (video 5)
- Use Data Storytelling (video 6, 7)
- Export and share Qlik apps (8)
- Global smart search of variables (video 9, webinar 1)
- Collaboration with Qlik Sense (video 11)
- Qlik Streams (video 11)
- Using Qlik on mobile devices (video 12)
- Know what Green, White, and shade of Grey represent (video 10)
- In depth data load (webinar 1)
- In depth data associations (webinar 1)
- In depth visualization customization (webinar 1)
- Global selections list (webinar 1)
- Exporting sheets (webinar 1)
- Master dimensions (webinar 1)
- Write basic functions for measures and dimensions (webinar 1)
- Writing custom widgets with HTML (webinar 1)
- Generating random data (webinar 2)
- Connecting Qlik and Dropbox (webinar 2)
- Embed Qlik Sense into WordPress (webinar 2)
- Installing Qlik plugins (webinar 2)
- Colour by expression (webinar 2)
- CrossTable (webinar 2)
- Class() function (webinar 2)
- Aggr() function (webinar 2)
- FirstSortedValue() function (webinar 2)
- Set analysis (webinar 2)
From hard data to fluid design – Scott