1 2 3 Previous Next

Qlik Design Blog

64 Posts authored by: Michael Tarallo

ny2018.pngWell guys - where do I begin? – Ah I got it, Happy New Year! <sigh> It feels like only yesterday that I was writing my first blog for 2017. However, after a long break, I’m excited to get back to work and contribute towards another prosperous year at Qlik! I didn’t want this to be another one of those “Year-in-review-type” posts…..so…I cleverly disguised it to highlight some of our product achievements during 2017. Think about it as a sitcom clip-show. So much Qlik goodness has transpired over the past year not only is it difficult to cover everything that has happened with the product, but as a consumer, I know it's difficult to keep track of it all, so I ‘ll do my best to summarize and consolidate where I can. This post is a bit long - so for some of you, I expect you to bookmark it and use it for later reference if needed.

ENTER TO WIN $50 Amazon Gift Card - Rules Below

So, let’s begin.


For those of you who want the short, short version:


  • Qlik GeoAnalytics
  • Qlik Sense 3.2
  • QlikView Converter
  • Qlik Sense Chat Bot
  • Data Connectivity
  • Qlik Sense June 2017
  • Advanced Analytics Integration
  • Qlik Sense September 2017
  • Qlik Sense November 2017
  • Qlik Sense Mobile
  • Qlik's Associative Difference


Qlik GeoAnalytics


Qlik GeoAnalytics Datasheet1-3.jpgIn January of 2017 – we kicked off the then new year with an acquisition of our Sweden-based partner, Idevio, creator of Idevio Maps. We introduced the recently acquired product as Qlik GeoAnalytics. Currently available as an extension for both Qlik Sense and QlikView, Qlik GeoAnalytics goes beyond traditional “points on a map” and adds a broader range of capabilities to support advanced geoanalytic use cases. During 2018 (no specific time-frame yet) we plan on integrating Qlik GeoAnalytics directly into Qlik Sense, so stay tuned.


ICYMI: Introducing Qlik GeoAnalytics


Qlik Sense 3.2



Soon after, in March 2017 - we announced our first release of Qlik Sense for the year, version 3.2. 3.2 added the ability to easily create time-based measures (Calendar Measures), included additional chart options to support custom colors and color assignments, introduced the QlikView Converter and added a new configuration to improve the performance and stability of multi-node deployments (Shared Persistence)

ICYMI: Introducing Qlik Sense 3.2



The QlikView Converter


ui-qlikview-converter-example-01.png With version 3.2 we included a utility found in the Dev Hub that simplifies converting a QlikView document (.qvw) over to a Qlik Sense app (.qvf). You simply upload your .qvw to the converter to be analyzed, and it will extract the data model, script, measures, dimensions, expressions, variables and even compatible visualizations. The user can then choose what they want to convert to create a starter Qlik Sense app. Next they can create new or modify existing visualizations using the assets that were already available in QlikView.


ICYMI: QlikView converter - Qlik Sense - YouTube


Qlik Sense Chat Bot


1.pngApril 2017 set a new milestone for Qlik by pushing the boundaries of analytics.  We demonstrated the art of the possible using the Qlik platform, its awesome APIs, and various 3rd party technologies - to create the first ever Qlik analytics chat bot. Simply stated, imagine getting your answers to your business questions by asking your digital assistant. Since the original bot debuted at the Gartner BI Bake-off and Qonnections there has been tremendous interest in this concept, which has evolved rapidly over the 2nd half of 2017. There is now a new community group: https://community.qlik.com/groups/qlik-chatbots with many supporting resources and our own Todd Margolis is leading the charge to help enable our community to take advantage of our two open-source Qlik Bots.  Whether you’re a business user and want quick and easy access to your KPIs on the go or you’re a developer and want to extend them with new capabilities or integrate Qlik into your existing bots, we’ve got you covered.




Data Connectivity

cloud+blog+2.pngOver the course of 2017 Qlik Sense and Qlik Sense Cloud had many improvements, especially in the area of connectivity. In May we introduced the first integration of our Web Connectors package to Qlik Sense Cloud – starting with access to Twitter, Facebook and Google Analytics.  Then in July we introduced on premise connections from Qlik Sense Cloud starting with MS SQL as well as the Web file connector. During 2017 we delivered over 20+ connectors to Qlik Sense and Qlik Sense Cloud Business including Dropbox, REST, Amazon Redshift, YouTube and many more.






In addition to the aforementioned connectivity we also debuted our new release schedule and product naming convention when delivering Qlik Sense June 2017. No more dot releases for us – new releases are now identified by the month they are delivered in. June 2017 brought us new visualizations (Histogram, Distribution and Box plots), enhanced visual data preparation features that support data profiling and data quality and a new Advanced Analytics integration framework – allowing you integrate with advanced analytics engines such as R and Python.




Qlik Advanced Analytics Integration (AAI) enables direct server to server data exchange between Qlik Sense and 3rd party calculation / analysis engines via a connector or what we also call a plugin. So for example, a specific forecasting function that is part of an R library can now be called from within Qlik script and chart expressions and calculated on the fly. Passing the results back to the Qlik analysis engine and subsequent visualizations. With this capability we now support the APIs that provide connectivity to such engines and provide starter connector projects for R and Python.


ICYMI: Introducing Qlik Advanced Analytics Integration


Qlik Sense September and November 2017


9-5-2017 1-20-11 PM.png

Continuing our commitment to deliver iterative improvements and features every 10 weeks, we released our September and November 2017 releases, which introduced our new Waterfall chart, continuous transformations using visual data preparation, our Qlik Sense Mobile app, visualization and navigation improvements and the introduction of our extension certification pilot.






Qlik Sense Mobile (offline)


Originally released to select participants in June, the Qlik Sense Mobile app for iOS became available to customers and partners in the Apple App Store later in the year. This iOS app enables its users to connect to their Qlik Sense Enterprise Server and download a local copy of their Qlik Sense app directly to their iOS device where they can analyze data on the device just as if they were connected to the server, allowing them to take Qlik Sense with them on the go in a disconnected state. (at this time Qlik Sense Mobile is for iPad only – a version for the iPhone is expected to be release early this this year.)





Qlik’s Associative Difference


assoc_thumb.pngFinally, analytics is more than just creating charts, it’s about finding answers. Therefore, I’d like to give an honorable mention to our team, who has created resources to help our prospects, customers and partners clearly understand the benefits of Qlik’s Associative Difference, powered by our patented associative technology. Sometimes referred to by many different names (Associative Experience, Associative Model, Green-White-Grey), Qlik’s Associative Difference separates us from those traditional query-based visualization tools. Qlik’s Associative Difference allows you to explore data freely in any direction, automatically associating every dimension in the data model which visually reveals how the data are related using the colors green, white and grey - AND -  without leaving any data behind.




Well guys – that’s it – your Qlik 2017 Year In Review – oh wait. - I said I wasn't doing a "year-in-review" post, ah @#$%&!.


Personal Giveaway Rules:


Do you have some interesting Qlik highlights or discoveries during 2017 that you would like to share? We want to know. Post them in the comments below OR if you would like to participate in my personal giveaway with a chance to win a $50 Amazon Gift Card (claim code) post a tweet using twitter http://twitter.com/ with your 2017 Qlik highlight or discovery and tag me using @mtarallo along with the hashtag:




...you will then be entered into a reviewed, random drawing to receive $50 Amazon Gift Card(claim code). Winner will be selected using Qlik's Twitter Connector and Qlik Sense app which will draw a random tweet using the hashtag: #Qlik2017Highlights. Winner will be announced on Twitter by @mtarallo on February 6th 2018 and in the Tuesday edition of the Qlik Design Blog. Entry must be an interesting or valid Qlik highlight or discovery - if not it will be discarded and the next entry will be selected at random.


Contest starts Tuesday Jan 9 2018 and ends on Tuesday Jan 30 2018. We want to hear from you!





Michael Tarallo (@mtarallo) | Twitter



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

Hey Guys! - Happy Friday! Yep I'm blogging on Friday this week and our Demo and Design Team will be taking my usual Tuesday slot next week, to blog about something many of you have been waiting for (mark my words) I think you ALL are going to love it - so until then you'll have to deal with me for today. So what difference does that make to you for today's blog?!?! Absolutely nothing!


Seriously though - back in September, with the announcement of Qlik Sense September 2017 Qlik Sense September 2017 - What's New - I made mention of an Extension Certification Pilot program which will allow extension authors to submit their extensions to Qlik for review, to be certified and supported by the author for use within the Qlik platform. So in this blog I am making good on my promise to update you on the progress of this with some detailed information that should answer a few questions.


In the November 20017 -  What's New in Qlik Sense November 2017 we made mention that certified extensions are now going to have some badging to identify that they are certified -- and that they will be made available on Qlik Market - our online partner solution showcase. However - we have had some members and partners with additional questions and I think the answers will benefit everyone.


What extensions are certified? (There is currently no badging or filter on Qlik Branch for these items)

The only certified extensions currently are the ones that we are planning to put on Qlik Sense Cloud in the near future. Once certified they will automatically be part of Qlik Sense Cloud and be available for installation with Qlik Sense Desktop and Enterprise. (available form Qlik Market)


Do you have any extensions that will be certified first?


These 4 are on the certification list, and final certification will be made shortly:


It’s important to note that the versions of these extensions available on Branch are NOT certified. Certified versions will only be available for use on Qlik Sense Cloud or available for download from Qlik Market (market.qlik.com). Only the versions on Qlik Market will be badged. The plan is for those versions on Qlik Branch to be the open source, work-in-progress versions, subject to change at any time, and therefore, can’t be certified.


What does certification entail for our customers, partners, community ?

For a customer, certification doesn’t entail anything different except using the certified version. For developers (whether they be our customers or partners, or outside of those communities) the certification process will mean submitting the extension to be run through a battery of tests to ensure that they run correctly, don’t use any undocumented APIs, contain no malicious code, and some other tests. If they want the extension to be listed on Qlik Market, there is another check that the QM team makes before they can be posted (mostly around brand compliance and usability).


How can I submit and extension?

The "official" certification program is not yet in place. The four extensions we certified were Qlik-created. We are not yet ready to accept outside submissions for certification but will have a process in place early next year, so please stay tuned.


Hope this information is helpful to you all and if you have any questions please post them below and I'll do my best to address them for you.


Have a great weekend everyone!



Michael Tarallo (@mtarallo) | Twitter



Additional Reference Resources:



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!



Michael Tarallo (@mtarallo) | Twitter

Senior Product Marketing Manager



Can't see the video?


Download the .mp4 and watch from your computer or mobile device.

Our Christof Schwarz is back and has created a video tutorial that shows you how to use PERSISTENT CUSTOM colors with Qlik Sense visualizations. Persistent colors map all dimension values to specific consistent colors that are represented equally in all charts on the sheet. When you perform selections - the values displayed will all be represented by the same color in the charts. However the colors can change when the sequence or number of values for that dimension have changed. So this tip will show you how to assign specific custom colors to those values so they don't change and remain "sticky" as Christof puts it.




Hey Guys - welcome to this week's Tuesday edition of the Qlik Design Blog. In this post we are excited to announce the availability of Qlik Sense November 2017. It has only been 2 months since our last release demonstrating our commitment to continuous and iterative improvements with our products. In this video I quickly breakdown what’s in the Qlik Sense November 2017 release. Included are some various chart improvements, new connectors and usability improvements to visual data preparation and the design interface. Let me know what you think, and leave a question or comment below.


Other videos for your viewing pleasure:




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.


Try Qlik Sense now: Try or Buy


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



Michael Tarallo (@mtarallo) | Twitter

drop.pngGood day Qlik Community! In this article / video - I'm excited to present to you a preview of the new Dropbox connector that comes with Qlik Sense Cloud Business and Qlik Sense Enterprise, available later this month. In short, Qlik Sense can now securely access Dropbox and pull data from Qlik Sense supported file sources, directly from the cloud share. The connector itself, is fairly simple to use. It's just like accessing a local folder structure. However, it gives you another option for storing data files for use with your Qlik Sense apps. It even opens some new techniques for refreshing file-based used by those apps. So, instead of storing data files in my Qlik Sense Cloud Workspace, I can choose to store them in Dropbox. With this approach I can automate a data file upload process when new data arrives..... add that to Qlik Sense Cloud Business and its Schedule Data Refresh capability, and you can completely automate the data upload and Qlik Sense app refresh process!


Want to learn more? Take a look at this brief video below to see how I used the Qlik Sense Dropbox connector and common, freely available Windows tools to make this happen.


NOTE: The approach I take in the video simulates data being written out / updated to disk and then transferred to Dropbox on an automated schedule using a 3rd party scheduler (Windows Task Scheduler). It is completely up to you how you would like to achieve this. For example, you could have a database process export files directly to the Dropbox folder, or even use an ETL tool workflow and its scheduler to write out data to the Dropbox share.


Have more ideas on how this can be achieved? We want to hear from you, so share them in the comments below.



Michael Tarallo (@mtarallo) | Twitter





Qlik Sense Cloud Business - Dropbox Connector - Refreshing file-based data


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 YouTube video?


Download it here to watch on your computer or mobile device?

Try the app here:







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. (video and sample files)

For more videos that can help you get started with Qlik Sense:

cloud blog 2.pngHey Guys! Thanks for taking a moment to read this blog and view the brief 60 second video on our Qlik Web Connectors. It is no surprise that we are surrounded by mountains of data. But, what good is it if you don't have easy access to it? I'm not talking about data that sits in traditional files and databases. I'm talking about data that sits in numerous cloud-based services, social media and web sites.Depending on your business, this data can contain valuable insights that help you make better decisions as wells as customer sentiments that help improve your products and services.


Our Qlik Web Connectors is the answer to your additional data needs, whether its from a cloud-based CRM, data warehouse or social media application. Watch the below video to learn how simple it is to fetch this data and bring it directly into your Qlik Sense or QlikView environments. And...Qlik Sense Cloud Business subscribers, guess what, you have access it to them too!


Qlik Sense in 60 - Qlik Web Connectors


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.


Qlik Sense Cloud Business Subscribers:

As stated in the video, Qlik Sense Cloud Business subscribers can also get immediate access to a great selection of many of our web connectors, with more being added on a regular basis. With Qlik Sense Cloud Business, subscribers can quickly and easily fetch data from many web-based sources with a new integrated connector selection list and query manager. The addition of these features, eliminates the need to copy and paste any script as you would when using the standalone Qlik Web Connector service.


How-To Videos

For more information on a list of Web Connectors just released for Qlik Sense Cloud Business check out our recent announcement here: Getting More Connected in the Cloud


Additional Web Connector Resources:


Learn more from my colleague Adam Mayer who shows some brief examples using Twiter, Facebook and Google Analytics:



We want to hear from you, so please join the conversation by posting your questions and comments below.




Mike Tarallo


Can't see the video?


Download the .mp4 and watch from your computer or mobile device

Coming from a traditional business intelligence and ETL background where I’ve used both proprietary and open source solutions – things like OLAP, data modeling, SQL, 4GLs, semantic layers and even coding dashboards were commonplace for many years. So when I started with Qlik, I was not only thrilled, but quite biased towards the way I manged and created analytics . As I set out to build my first Qlik application I immediately had many questions:

  • Where do I build my semantic / metadata layer?
  • Where is my data modeler tool to define my table relationships?
  • How do I place parameters to pass where-conditions to my database?
  • How do I wire my visualizations to make my dashboards interactive?


As I set out on this journey to appreciate Qlik, I was surprised at what I found. In this multi-part blog series I will share with you some of my pleasant surprises that changed the way I create and work with analytics.

So let’s dive in further to my first Qlik pleasant surprise.


#1: Where's the "Semantic Layer"?!


NOTE: The subject matter in this topic can have many moving parts and is not meant to be a direct comparison to traditional BI or other data visualization tools. It is an expression of my experiences when first working with Qlik and meant to inform those who might have similar expectations when comparing Qlik to other BI tools.

A typical first step when using BI tools is that you usually create a metadata or semantic layer before you can begin creating your reports and dashboards. Depending on the tools being used, sometimes you even need to create more than one…one layer to support operational reporting and one to support interactive OLAP. (Often when a vendor's software stack combines a number of acquired tools, you may see this occur.) Creating abstraction layers such as these are usually performed by BI administrators whom are familiar with the data. Metadata / semantic layers provide a unified, consolidated view of data across the organization. They are important middlemen that connect back-end data to BI client tools and add a layer of governance and security. These centralized repositories store many attributes of your data including specific attributes used by the tools:

  • Connection information
  • Business friendly field names
  • Field and row-level security
  • Aggregations
  • Data modeling properties such as keys, and referential integrity
  • Calculated expressions

Once a semantic layer is prepared, the BI client tools can begin using the "data models", "business objects", "data dictionary" etc, to create reports and dashboards.

Now, when I started working with Qlik, I was unsure how this step was performed -OR- perhaps what I was doing seemed more transparent and less rigid than what I was used to. For starters I could quickly load data directly from many sources and go directly into my analysis. Qlik simply loads and indexes data into its apps during the app creation. These apps then operate within an associative indexing engine. (more on that in another article) - If I wanted to add multiple sources, I can visually profile the data and define relationships automatically - no complex data modeling or SQL required. I did not need to worry if I was "joining" correctly or even understand the relationships of the tables. I found this to be a huge time-saver and the process was fairly simple to navigate. This was indeed a pleasant surprise.

10-10-2017 8-20-16 AM.png

Once the data was loaded into the app, I immediately had access to my fields and could begin creating my analysis. In addition, I discovered that I can also set up reusable expressions, measures, dimensions and even predefined visualizations, through a feature known as Master Items. Master Items are defined in the Qlik Sense App rather than a centralized server. They allow business users to use a pre-defined library of assets so they can easily create and customize visualizations. (Note: Master Items are more beneficial to users of Qlik Sense Enterprise as opposed to those using Qlik Sense Desktop.)


This was a pleasant surprise as it was extremely easy to get started with Qlik and cut my data preparation time significantly, in turn giving me more time to create my analysis.So basically, I discovered that Qlik, defines its "semantic layer" within the app itself, as opposed to a separate repository?!? Hmmm.....

A healthy debate ensues

To some degree, I understand there are some opinions about this approach, and some may say "That's not a semantic layer". Now there are ways that you can export a Qlik data model and data index, created within the app, to disk (.qvd) and use them with other applications. This has been done widely and successfully by many of our customers. But...with the new Master Items approach introduced in Qlik Sense, we needed a way to centralized those assets for other applications as well, so our team of experts have created a Qlik Powertool, the Governed Metrics Service.

"The Governed Metrics Service (GMS) Powertool provides the ability to control and provision the use of governed Master Items. GMS loads externally defined metrics and applies them to one or more designated applications. GMS will quickly have you on the right track to governed self-service."

To learn more about GMS check it out here: Introduction - EA Powertools Governed Metrics Service

My journey with Qlik is no where near completed and I anticipated many more pleasant surprises. Next week I'll cover another pleasant Qlik surprise that helped me uncover things in my data I had not idea existed. Have a comment or question, a pleasant surprise you want to share? We want to hear from you. Use the comments section below to ask a question and join the discussion.


Michael Tarallo (@mtarallo) | Twitter

For starters, if you are a visual learner and new to Qlik, take a look at this brief video to get an idea of how to provision from multiple tables using Qlik Sense:


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. (video and sample files)

For more videos that can help you get started with Qlik Sense:

Hey guys - thanks for joining me in this Tuesday's edition of the Qlik Design Blog. Today I have provided a video that walks you through the Qlik Sense Data Load Editor and at the same time highlights a simple use case example where Qlik Load Script can come in handy....loading data from an Excel file, while looping through its multiple sheets.


As you may know Qlik Sense has a powerful visual data preparation interface to help you profile and prepare data for analysis, but did you know that Qlik also provides advanced scripting capabilities to help you transform and augment data as well as perform many other tasks, including those you may found in popular programming languages?


Some common examples include:


  • Incremental loading
  • Adding row and field level security: Section Access
  • Creating .QVD files
  • ...and more


Watch this brief video to learn about the Data Load Editor and see it in action, read on to learn about what else Qlik Script can do.





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.




You can learn more about what other great things Qlik Script can do in these awesome blogs by our Jennell McIntire jmc:



...and many more. Stay tuned to the Qlik Design Blog on Fridays, where Jennell and team blog about many interesting Qlik design topics.


Can't see the video? - You can download the .mp4 attached to this post.


Samples files used in the video also are available.


Visual Data Preparation References:





Michael Tarallo (@mtarallo) | Twitter

Hello Qlik Community! Qlik's Bruno Calver is back sharing his in-the-field experiences, building upon his User Experience white paper made available last year. This time he has authored a white paper on Data Literacy. Bruno has worked with many large global enterprises, helping them discover the value in their data and how to best represent it in order to drive results.  During this time he has come across many different ways of working with data. This article tries to consolidate the key take-aways within the context of data literacy. Be sure to download the attached PDF at the bottom of this post to learn more.



Literacy skills have always been top of the bill in the education system -- and for good reason. Equally, data literacy skills are climbing the agenda in today’s competitive business environment.


Organizations will soon rely less and less on pre-processed information and their gut instincts as a decision making paradigm. It is increasingly important for everyone to apply critical thinking skills to every problem and data set in order to achieve a competitive advantage and create truly innovative solutions.


However, for many of us it is not clear what data literacy means, let alone the skills and techniques that might help drive our own data literacy level. The attached article explores these concepts and provides 5 key areas to think about when analyzing your data - including practical examples:


  1. Trends & Context
  2. Internal & External Data
  3. Cohorts & Cell based analysis
  4. Averages, Aggregation & Distribution
  5. Bias & Non-Causal Correlations


Increasing data literacy skills can have a profound impact on organizations in the following ways:


  • Increasing user adoption and awareness of analytical tools and capabilities
  • Creating data driven cultures to enhance performance
  • Unlocking more value from your data investment


If this sounds interesting, then please read the article and see what new things you can discover about the language of data…!



Bruno is a Principal Solution Architect working in the UK with some of Qlik’s enterprise customers. His passion is working with business people to turn disparate and otherwise mundane data sets into insights and stories that can engage their audience, drive change and inspire new ways of thinking.

Hey guys, happy Tuesday! I'm pleased to be back in this edition of the Qlik Design Blog to introduce you to the September 2017 release of Qlik Sense....right off the heels of hurricane Irma I might add. Florida (my home state) and its surrounding neighbors have been hit hard by this storm and I would like to first express my deepest sympathy for those that were affected by Irma's wrath. We will recover, as we always have, and by working together and supporting one another, we will be back on our feet in no time...oh and hurricane Maria, you better watch yourself Missy!) Now on to the show!


As we have previously mentioned, Qlik will be releasing software 5 times a year. Which equates to a new release about every 10 weeks or so. (You can learn more about our continuous release cycle by checking out this blog here: Qlik Sense® will release 5 times a year!)


Rather than list the new feature highlights in this blog, I created a brief video to cover and demonstrate them. You can always check out the Qlik Sense release notes on the Qlik Help site as well as download the attach data sheet to learn more. You can also try these features right now by logging in to the Qlik Sense Cloud or by downloading a free version of Qlik Sense Desktop: Download Free Data Visualization Development Platform.




Now remember, each release will vary in capabilities and features, with some releases possibly having "more" in certain areas than others. It is important to note that the releases will not only cover Qlik Sense specifics, but other product areas such as Qlik NPrinting, Qlik GeoAnalytics, Qlik Sense Mobile, Qlik DataMarket, data connectors, API enhancements and new services and procedures. For example, with the September 2017 release we are also introducing a new Extension Certification Pilot program to allow extension authors to submit their extensions for review, to be certified and supported by the author for use within the Qlik platform. Stay tuned for more information on this pilot program to learn how you can submit your extension for certification.


NOTE - Qlik Sense Mobile: The app is available on the iOS VPP app store (Apple’s enterprise app store) this week.



This is a huge milestone for Qlik as it brings the power of our Associative Technology to the iPad, online AND offline. Customers and partners need to have signed up for Apple’s enterprise developer program to get access to the app. Once they are members of enterprise developer program, they can download the app from https://vpp.itunes.apple.com. Most medium and large business have this relationship with Apple and for those who do not, we are bringing the app to the iOS public app store in the near future, so hold tight.





Mike Tarallo


Additional Resources:

* To learn more about extensions - check out these videos:



* Did you miss what's new in our Qlik Sense June 2017 release? - Check it out here: Qlik Sense 2017 Releases - What's New


* More Videos


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

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.




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.

einsteinshow.jpgIn this week's Qlik Design Blog I am pleased to share some tips from our own Mitul Vadgama of our Qlik Consulting Services team.  Mitul was recently working at a customer site when he noticed something that seemed a bit off when analyzing the customer's data. On the surface after loading the data everything appeared fine - but once they started performing selections, Mitul was able to identify the specific cause with the help of Qlik's Associative Difference, the elusive <NULL> value.


The Problem


The customer's data model had about 300+ fields with a number of these fields being of a nominal data type (also known as categorical data). Put simply, I like to describe nominal data as the attributes in the data that don't carry a numerical value. Examples of nominal data are as follows:





Mitul found that when business users were selecting values in a nominal field it gave the correct result, however when they performed advanced selections such as using the the Select excluded option available in a select list, the results did not match up against what was expected. Thanks to Qlik's Associative Difference they were able to quickly and easily identify that <NULL> values were being excluded when the customer performed a Select Excluded selection. Yes, I know that sounds weird, the Select excluded option excluded <nulls> from the exclusion selection. (read-on and watch the quick video so this makes more sense to you )


Click to enlarge image


The Fix


One way is to use the NullValue variable and NullAsValue statement set in the Data Load Editor settings.  (Qlik Help)



Set NullValue='<NULL>';

NullAsValue Field1, Field2;


In our example data we have <null> values in the StateProvince and OfficeStateProvince fields both in the Customers, and Employees tables. In the image above you can see that the <null> value is also not select-able in the filter pane.




Set NullValue='<Unknown>';
NullAsValue StateProvince, OfficeStateProvince;


After adding these settings to the Data Load Editor we were able to get the correct results as the <null> values were now being taken into consideration.


Click to enlarge image


Companion Video: Replacing Null Values in Multiple Fields


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.


We hope this post has shown you another efficient way to handle <null> values in your Qlik application.


I'd like to thank Mitul for his valuable contribution to the Qlik Design Blog.






About Mitul: Mitul is a member of our Qlik Consulting Services team in the UK. He has worked on a variety of consulting projects using both Qlik Sense and QlikView with many enterprise customers. His passion is transforming data into valuable business insights, knowledge sharing, and enabling customers to get the most value out of Qlik products.





Can't see the video?


Download the .mp4 and watch from your computer or mobile device.

Filter Blog

By date:
By tag: