1 2 3 Previous Next

Qlik Design Blog

84 Posts authored by: Michael Tarallo

Hey Guys,


Watch this video to learn what's happening at Qlik.


In the video I cover:




Qlik Community Update


Can't see the video? YouTube blocked by your region or organization? Download the attached .mp4 to watch on your computer or mobile device.



Michael Tarallo (@mtarallo)


Hey Guys - this particular post may not be relevant to everyone, yet it is an integral part of making sure that a software's capabilities can be used by those who have impairments. With the release of Qlik Sense June 2018, we have added some new accessibility conformance features that comply with WCAG 2.0 standards.  To learn how we are making Qlik Sense more accessible to everyone, please check out this brief video below. Please let us know what you think and post any question, I'll be happy to address them.



Qlik Sense Accessibility




Michael Tarallo (@mtarallo) | Twitter



Can't see the video? YouTube blocked by your region or organization? Download the .mp4 to watch on your computer or mobile device.

Michael Tarallo

Using IntervalMatch()

Posted by Michael Tarallo Jun 12, 2018


Hey guys, I was recently at a user group meeting and the topic of IntervalMatch() came up with regards to when and where it was best used. I liked the topic and subject matter that was covered, so I decided to create a quick video showing you how I used it when rating or grading some video game consoles. Note that IntervalMatch() can be used in many situations, however there may be other approaches to achieve similar results. View the Qlik Help topic here.





IntervalMatch is a data load script prefix that creates and links a table used for matching discrete numeric values to one or more numeric intervals where there may not be any specific link or key available between the tables. This is used in situations that utilize interval scales of data such as population, date ranges, temperature, number of units, scoring etc. to name a few.


Let’s imagine I have a number of video game consoles that vary in condition. I want to assign them a rating from good to worst based on a numeric scale related to overall condition and function. I have a grading table that contains the numeric ranges for the grade as follows. Note the Grade field description and the High and Low field range values.


6-12-2018 1-15-24 PM.png


I also have a table that contains my consoles names and their individual rating numeric value.


6-12-2018 1-15-40 PM.png



Since these two tables don’t have a common link between them, when the data is loaded and I select a value from either the console or the grade lists, I cannot see any of the relationships.


6-12-2018 2-17-57 PM.png



I can easily solve this using the IntervalMatch prefix which will look at the data already loaded from the grade table with the numeric intervals and match it to the Rating field in the consoles tables. IntervalMatch must come after the initial data is loaded and before the load statement as shown. (Please note that your interval field order is important, starting with the field containing the lowest interval value first.)


[Grade Ranges]:
FROM [lib://AttachedFiles/console_grades.xlsx]
(ooxml, embedded labels, table is [Grade Ranges]);

[Console Rating]:
FROM [lib://AttachedFiles/console_grades.xlsx]
(ooxml, embedded labels, table is [Console Rating]);

[interval match table]:
Resident [Grade Ranges]


Upon loading the data – you can now see that the tables are now linked with this new interval table. Technically a synthetic key is created but in this situation I am told it is nothing to be concerned about. Now you can clearly see the grade of my consoles by either selecting the Grade or the Console list values or within the table visualization.


6-12-2018 2-22-02 PM.png6-12-2018 2-22-16 PM.png


As always there usually is more than one solution to these types of problems, and perhaps some may be more optimal than others. I’d love to hear from you, so if you have another approach please share it with us.



Mike Tarallo
@mtarallo - Twitter


Can't see the video? YouTube blocked by your region or organization? Download the attached .mp4 to view on your computer or mobile device.

martin.pngHey guys! I'm pleased to introduce our newest guest presenter in the Qlik Design Blog, Martin Tombs, Global Pre Sales Director at Qlik. Martin has created a video presentation (embedded and attached below) which will help our partners learn how to take advantage of our Qlik Technical Sales Tools - recently announced at Qonnections. I had a chance to view this video in greater detail to prepare the intro and body of this blog - and it is absolutely amazing what the Pre-Sales organization has assembled AND now made available to our partner community!


If you are a Qlik partner, I highly recommenced you invest the 20+ mins to review this presentation and demonstration video. These tools are now being opened up to our partners as a way to facilitate self-sufficiency during the professional phase of the sales cycle.


Qlik Technical Sales Tools can be accessed from the Qlik Partner Portal and currently consists of:


  • Presentation Explorer - Online Qlik application, including 400+ slides & speaker notes, search and build your presentation
  • Technical Insights - Search for answers to questions, samples questions with contextual answers and articles - great for RFPs
  • Sizing Advisor - Online Qlik tool used to deliver hardware recommendations with PDF report generation
  • Qlik Machine Images (QMI) - Automation for demonstration within personal environments of many Qlik product scenarios




Can't see the video? YouTube blocked by your organization or region? Don't fret, download the .mp4 file to watch on your computer or mobile device.


I'd like to thank Martin and the Qlik Pre-Sales organization for sharing this remarkable resource. Please post comments and questions below, we want to hear from you - myself and our team will do our best to respond. Take care all.



Mike Tarallo


Our David Freriks is back introducing a free, open source utility that provides a visual exploration front end that helps you understand the “big data” that exists inside the Cloudera data lake. It allows a user to visually understand how to create fully interactive Qlik apps on the data of interest to them.


Cloudera Data Lake Explorer is Qlik Associative Engine API based application that leverages metadata from Cloudera (Impala, Navigator, Manager) to browse the width of the data lake and build a self-service Qlik Sens application with no scripting required.  The explorer interface uses the power of the Qlik Associative Engine to show how all the metadata correlates between databases, tables, columns, metadata tags, and sql queries. Watch the video below to learn more.


This application has been published to Qlik Branch (http://branch.qlik.com/#!/project/5afb0d76fefa01686177560d ) and is hosted on Github. The Cloudera Data Explorer is a new take on how to use the power of Qlik to navigate, understand, and leverage big data in a way that simplifies the experience for the exploratory user.




David Freriks (@dlfreriks) | Twitter




David is a Technology Evangelist on the Innovation and Design team at Qlik. He has been working in the "big data" space for over three years, starting with Hadoop and moving onto Spark in this continuously evolving ecosystem. He has 18+ years in the BI space, helping launch new products to market.

Hi folks - this video will show you how to get started with Qlik Sense Mobile from a basic sense. There have been some signifcant changes since I last recorded a video on this and it was time for a brief update. Due note that we have much more for those of you who administer, secure and deploy mobile BI. We work with Enterprise Mobile management vendors to tightly integrate our solution with their platforms. See the resource links below.


In this video you will learn how to:


  • Install the Qlik Sense Mobile App on iOS
  • Configure and Send Client Authentication Link Using the QMC
  • Verify Offline Security Settings
  • Start the app and login to your server
  • Download your app
  • Access your app offline


Note: Offline access via the Qlik Sense Mobile App is only available to Qlik Sense Enterprise customers. However, Qlik Sense servers and Qlik Sense Cloud can be quickly and easily accessed via a mobile device such as a tablet or smart phone by simply using a mobile browser that supports HTML5 - i.e. Chrome, Safari, etc. Check out these 2 videos to learn more:


Please let me know if you have any comments or questions.



Qlik Sense Mobile







Michael Tarallo (@mtarallo) | Twitter


Can't see the embedded video? YouTube blocked by your organization or region? Download the .mp4 to watch on your computer or mobile device.

layout.pngHey guys - I recently was inspired at Qonnections 2018 by our Big Data Qlik IoT Race game, so much so that I had to understand how it all worked and wanted to play with the underlying technology. Aside from gathering the statistics and providing an analysis on the results, I was really interested in learning about those little devices or "things" that were connected to the track. However, how would I use something like that? Not really knowing anything about Arduino, WEMOS and IoT in general, I set out on a mission to learn about this fascinating technology while incorporating somethings I enjoy such as Qlik and retro-gaming. Take a look how I made IoT interesting and fun to learn, by incorporating a Retrogaming spin and of course added some Qlik Sense data analysis.



5-9-2018 9-47-26 PM.png

Atari Action Analysis Dashboard




Thanks guys, hope you enjoyed it. Let me know what you think by leaving your questions and comments. I'll do my best to respond.


Can't see the video? YouTube blocked by your region or organization?


A copy of the video can be downloaded or streamed from here:



Michael Tarallo (@mtarallo) | Twitter

thumb.pngHey guys - what a week we had at Qonnections! If I met some of you while attending, it was a pleasure to meet you in person and I'm glad we had a chance to chat. I look forward to working with you in the Qlik Community.  I also hope you have seen all the great content created by our Qlikies, analysts, partners and colleagues. Be sure to check our corp blog for the latest highlights and references. As we play catch-up and recoup from Qonnections withdrawal, one particular feature made a good impression on many that I spoke with at Qonnections.  So much so I decided to create a Qlik Sense in 60 on it to showcase it.


Within in the April 2018 release of Qlik Sense, you can now publish Qlik Sense apps to - AND - move apps from - Streams directly from within the Qlik Sense Hub. Making it much easier for content admins to share their Qlik Sense apps with the greater community. Check out this quick video to see how it is done:



Qlik Sense in 60 - Publish and Move from Hub



Michael Tarallo (@mtarallo) | Twitter


Can't see the video? YouTube blocked by your region or organization? Download the .mp4 to view on your computer or mobile device.

Hey guys - it's What's New in Qlik Sense time and I have prepared a brief video to share some of the awesome highlights in our next release Qlik Sense April 2018.



Highlights include:


Assisted data visualization with Qlik Sense chart suggestions / recommendations

Qlik Sense recommendations make it easier to create a visualization by allowing you to simply drag and drop fields onto your sheets. Chart suggestions are created using the Cognitive Engine in Qlik, which leverages insights from the data loaded and combines them with best practices for data visualization.


NEW Grid Size control

Now with the creation of a new sheet, the application author can choose between 3 grid sizes - small, medium and large.


Maps visualizations improvements

Qlik Sense April 2018 features significant improvements to the built-in maps visualization:

  • Support for multiple layers.
  • Labels for point layers and area layers.
  • Quick look up of countries, divisions, cities, postal code areas.
  • Circle select with distance measure.
  • Drill down support.
  • Layer control, zoom limit and draw order.
  • English or local name in the background map.


Publishing an app from the hub

In Qlik Sense April 2018 you can publish an app that you have created to any stream for which you have publish access. If you have published an app to a stream, you can move your app between the streams for which you have permission to publish.


Qlik Geocoding
A new subscription service part of the Qlik GeoAnalytics product package, that allows you to coordinate geo lookups all the way down to the street level.


Also included:


Keyboard navigation support for Qlik Sense hub

To improve accessibility, Qlik Sense hub now supports keyboard navigation and shortcuts.


Linking Qlik Sense Mobile to third-party applications

Qlik Sense Mobile can now interact with third party mobile applications through a custom generated URL (deep link). The link can be embedded within the third party mobile application, with appropriate selections and filters. Clicking the link opens the app in Qlik Sense Mobile with the filters and selections that were applied during original presentation. As a result, user experience is improved and context is provided when interacting with the app.


Enable anonymous users to export data

From Qlik Sense April 2018 anonymous users can print and export data.


For a complete list of fixes and improvements check out the release notes in the Qlik Help site.


You can download it from our customer downloads site or play with it right now on http://qlikcloud.com/.


Note: Our amazing product content and media team has also produced a number of updated videos supporting this release, check them out here on the Qlik Help YouTube channel:


Qlik Sense April 2018 Playlist


Can't see the video? YouTube blocked by your region or organization? Download the attached .mp4 to play on your computer or mobile device.


Additional resources:




Michael Tarallo (@mtarallo) | Twitter


Hey guys - I know you will love this blog and video as much as I enjoyed making it; working with this really smart feature in the Qlik Sense April 2018 release. Here I will present a new feature made available in Qlik Sense April 2018, Chart Suggestions / Recommendations. If you have tried the Qlik Sense 2018 Technical Preview, then you have already got a glimpse of the power of the new Cognitive Engine. In my opinion the best part of this release are the new capabilities and future possibilities brought about by the new Cognitive Engine. Its main purpose is to streamline and enhance the analytics creation experience - taking you from data to insight in a matter of seconds / minutes. In short the Cognitive Engine leverages best practices, augmented intelligence and perhaps a little elf magic - along with your loaded data, to not only recommend data model associations BUT also suggests the best visualization for your data. All you need to do is drag and drop measures and dimensions either on to the design canvas or chart objects and the suggested visualization will display -  best depicting your data (no magic words required).  Allowing users to focus their efforts on gaining insight instead of building charts. Let me give you a quick demonstration.


You can try this right now in Qlik Sense Cloud!




Can't see the video? YouTube blocked by your region or office? Download the .mp4 to watch on your computer or mobile device.


Sample data attached.

1 f6YOV8dKjI9lXCC7TUpjIQ.pngImagine having a suite of proven tools and technologies built for developers by developers that allows you to build highly-scalable, cloud ready solutions using the power of the Qlik Associative Engine. Well, imagine no longer last Friday, 4/6,  we released the Beta of Qlik Core. Qlik Core is a development platform built on top of the Qlik Associative Engine. With Qlik Core, you can take advantage of the powerful associative indexing engine from Qlik to build your custom data exploration and data visualization solutions.


Please note that Qlik Core is a product - but it is not something you simply download and install with an installer. It works with technologies such as Node.js, Docker and Kubernetes and development knowledge of working with APIs is a prerequisite.  To learn more about the Qlik Core Beta and to get started watch this brief video below and visit https://branch-blog.qlik.com/introducing-qlik-core-beta-30221d627132 - where our product manager John Trigg provides some more of the particulars. You can also visit the many getting started resources here https://qlikcore.com/.


This brief video below is a short promotional video designed to briefly introduce Qlik Core.


Introducing Qlik Core



Michael Tarallo (@mtarallo) | Twitter



Can't see the video? YouTube blocked by your region or organization? Download the .mp4 to view on your computer or mobile device.

My buddy from down under is back in this week's edition of the Qlik Design Blog. Lee Mathews, Qlik Principal Solution Architect based in Melbourne Victoria, Australia, shows and tells how Qlik Sense can be used for financial reporting.


Financial Reports with Qlik Sense


I often have customers asking how they can produce financial style reports in Qlik. These reports are actually quite difficult to produce in most BI systems, as they usually require calculations and formatting that needs to change row by row. Most BI systems produce tables of data that display a single calculation in each column, with a dimension being used to provide a breakdown for the rows. Qlik is actually no different in this regard, however there are several aspects of the Qlik platform that provide the flexibility to replicate structured financial reports. Let me briefly introduce these aspects below:

  • Qlik’s powerful Extract Transform and Load (ETL) capabilities make Qlik the ideal platform for combining and reporting on data from disparate systems. But these ETL capabilities also allow you to take a data set and restructure it to include the necessary sub-totals that must be displayed in a financial report for example. You can also then flag these sub-totals in the data model so that different formatting can be applied to them in the UI.

  • Qlik’s extensive APIs allow visualization extensions to be created easily, with formatting options specifically for structured financial reporting. Two such extensions are illustrated in the video below, along with the use of the standard Qlik Sense pivot table object.

  • Qlik’s flexible expression syntax allows for a variety of tricks, to ensure that the right expression is displayed on each row. This includes Pick/Match functions, If Then Else logic, and of course Qlik’s powerful set analysis capabilities.

3-27-2018 10-40-08 AM.png

The short video below shows several approaches to producing structured financial reports. It is by no means an exhaustive list of techniques, but is a good overview of some of the options available.




Lee Matthews
Principal Solution Architect


Qlik Sense for Financial Reporting


Can't see the video? Download the .mp4 to watch on your computer or mobile device.

Hi guys - when working with a customer requirement, I recently discovered some additional controls one can implement in a published Qlik Sense app. There may be times, when you want to hide additional fields that are displayed in the Qlik Sense design interface. Now these fields are commonly ID and KEY fields which may not be necessary to one's analysis and the requirement might not always be for any specific security...as in our example they simply just want to control the visibility in the interface to reduce clutter and confusion.

Under default conditions, these fields will be displayed in the data visualization's field selector, the data properties drop down and in the expression editor. During this discovery, I was under the impression that when a user (consumer / viewer / non ContentAdmin role) - who can create their own analysis from a approved base app, they would only see the measures and dimensions populated in the Master Items panel on the left. While this is true, I discovered that the aforementioned user interface components, still display ALL the fields.


Here is how you can control that: Use system variable HidePrefix

set HidePrefix='_' ;

Watch this video to learn more:




Note: The data model fields are STILL accessible - however one would need to know what the prefix character is in order to use it in the expression editor or to be able to access it.


3-19-2018 5-18-41 PM.png


If you need an extra layer of security - where access to certain fields and data are restricted per user, group, or role then you would use section access to control the available fields and data from displaying.

One of our community members has also made mention you can use:



Tag Fields

[Hidden Field 1],

[Hidden Field 2],

[Hidden Field 3]

with $hidden;



Thank you!


Can't see the video? YouTube is blocked by your organization or region? Download the .mp4 to view on your computer or mobile device?



Michael Tarallo

Hi Guys - do you have 4 minutes? Good, then let's forego my normal formalities this morning and jump right into it!


Here are some recent product and resource updates s well as an informal list of features for the next release of Qlik Sense - April 2018.


Let us know what you think in the comments below.




Michael Tarallo (@mtarallo) | Twitter



Links mentioned in the video are:





  • Can't see the video?
  • YouTube blocked by your organization or region?


Download the attached .mp4 to view on your computer or mobile device.

Hey Guys - if you have been following Qlik, then you know that once again Gartner has placed us as a leader in the Magic Quadrant for Analytics and Business Intelligence Platforms for the 8th year in a row ... AND.... you know that every year around this time we participate in a friendly, live, on-stage Business Intelligence competition know as the BI Bake Off. This informative and exciting session is held during Gartner's Data Analytics Summit and hosted by BI research VP Cindi Howson, previously of (@BIScorecard) fame. It's a time and place for Qlik and its competition (Tableau, Microsoft, MicroStrategy) to showcase their greatest strengths...and possibly expose a few weaknesses - in front of many organizations' data analytics leaders. Overall, despite our competitive spirit, it is an awesome experience and a fun time to be had by all. Our presenter Josh Good (@joshdotbad) - led an entertaining and interesting session, showcasing Qlik's solution.

DXeP-6nVAAAcTkg.jpg large.jpg

Prior to the event, the Qlik team prepares a solution following a provided script based off of a public data set given to them by Cindi. Data usually centers around a topic in which each vendor can show how they can "do good" with the data, which is consistent enough to facilitate a side-by-side comparison. In the past we have analyzed traffic fatalities, homelessness and college debt, but this year the data centered around the deeply emotional opioid epidemic plaguing this great nation.

During the session, each vendor takes turns using their software to present their analytics while showcasing the capabilities of their software within a few different categories.


Qlik on stage - on the big screen - BI Bake Off Gartner Data Analytics Summit

Take a brief look at Qlik's solution highlights reel presented for each topic and let us know what you think by leaving a comment, question below - the timecode links for the section categories are listed below:

Gartner BI Bake Off Qlik Highlights Reel

To see an actual Qlik Sense product demonstration analyzing the Opiod Crisis check out this webinar presented by the Qlik Healthcare team: Analyzing the Opioid Crisis with Qlik - Webinar - YouTube

Analyzing the Opioid Crisis with Qlik - Webinar

We'd like to thank the entire Qlik team for a job well done as well as Gartner and Cindi for hosting another great event. Stay tuned to learn more about our future capabilities and be on the look for Cindi's take on the Bake Off on her blog space at Gartner.


Michael Tarallo (@mtarallo) | Twitter



Can't see the video? Access to YouTube restricted? Download the .mp4 attached to this post.

Filter Blog

By date:
By tag: