QlikView Set Analysis – A Scary Subject Set Analysis is a scary subject. I would surely claim it is the most difficult part of developing your QlikView front-end. I have waited to throw my hat in the ring regarding set analysis. This is mostly because I didn’t feel I had much to add, but also because Set Analysis in QlikView is a formidable subject. But the time has come for LivingQlik to cover Set Analysis. Firstly, no self-respecting blog would be complete without tackling the subject. Secondly, I feel that there is room for a compete reference presented in a clear voice. Can LivingQlik ..read more

Here is a simple Qlik Sense application that will email an administrator when a task failure is detected. Working with Qlik Sense for a while now, it occurred to me that I do not have an easy way of receiving alerts via email when a reload task fails. In QlikView, this was an automatic as the QMC has a setting where you can input an email address and you will automatically receive an email when a task fails. But alas, as of the publishing of this article, no such automatic feature exists in Qlik Sense. Well worry not, because here is a pretty simple way that to add this feature to your own ..read more

Finally the Qlik Sense Book I Have Been Waiting For If you were searching for a complete guide to Qlik Sense, finally it is here. Mastering Qlik Sense is a new book by Martin Mahler and Juan Ignacio Vitantonio. I say finally because this is the first offering that in addition to the normal guides and how-to’s, Mastering Qlik Sense provides in-depth information on server security rules and the development side of the platform including extensions and mashups. The Authors This book is written by a couple well-known heavy-hitters in the Qlik ecosystem. Martin Mahler has hit his stride with th ..read more

You need to upgrade your Qlik skillset. The folks at Websy will help get you there. For a while now, the winds of change have been blowing on the Qlik consulting front. As Qlik Sense, the product, grows from toddler to teenager its true potential is becoming apparent. The data-side massaging is becoming easier and less intensive as the opportunities to extend Qlik outside the hub gain importance. Although I have not seen any waning in traditional Qlik developments yet, I thought it was time for me to invest in some continuing education. If this is where the opportunities will be in the com ..read more

Qlik Sense June 2017 is Finally Here! The new version of Qlik Sense has been presented to the unwashed masses. There are 3 new visualizations we will focus on today, but there are several other great additions to the platform that are worthy of exploration: 3 New Visualizations Improved Data Preparation Script-side dimension color assignment On-Demand Apps The new Analytic Connector – Will connect third-party engines like R to the front-end Qlik Sense experience Today we will take a look at the new promised built-in visualizations. They are: Distribution Plot Boxplot Histogram As with ..read more

Another Qonnections is in the books.  Like all Qonnections (this is my 5th), it has passed like a whirlwind of activity and fun. I will try to sort through the experience to find some of the random notables coming out of Qonnections 2017. Product News The Fisheye was one of the clip-on camera lens provided in our “swag bag” this year. Very cool. The most exciting information came out of the day 1 general session. Anthony Deighton revealed the 2020 Vision and Roadmap. The overall vision is that unlike the “scary version” of AI where the machines take over the world, Qlik is embracing ..read more

Many Qlik Developers I meet have really awesome Qlik dashboards they have created. The dashboards I have created are like my little offspring. Some are ugly, yet functional. Some are super-colorful POC demos that never see real use. And some are that happy balance of intriguing visualization combined with useful insight. This is an opportunity for you to be a part of LivingQlik. To participate, just find your favorite QlikView or Qlik Sense dashboard sheet that YOU have designed. Then upload it using the form below. It can be a fun application, or extremely useful or incredibly unique or v ..read more

Today, I will cover some basics on how to create dimension groups for your QlikView applications. I will also talk about using GetCurrentField to make your charts behave more seamlessly with your groups. This info is must-have for any serious QlikView developer. What are Grouped Dimensions? When you build a chart, you typically will use at least one dimension field so that the aggregation in your expression gets calculated for each value in your dimension list. This is a simple concept that we can expand on. Grouped Dimensions allow the user to “switch out” the dimension with another ..read more

Every year, the worst movies of the year coming out of Hollywood are “honored” with an award called the Razzie. In an industry that normally pats itself on the back at every turn, the Razzies are a nice way to recognize that not every film churned out of the Hollywood machine is worthy of praise. In similar fashion, I thought it would be fun to award some of the worst data visualizations coming out of our collective BI industry. Although it is always fun to poke fun at data visualizations that might be lacking in usefulness, it is also an opportunity for us to learn so that we do not make ..read more

  I am a QlikView Ninja! QlikView Ninjas can quickly slice and dice QVDs with exacting precision. How do I do this with the skill of a Ninja? Well, I use my Ninja Sword of course! In this case, my blade of choice is a finely crafted weapon forged from the hands of the developers at EasyQlik. This weapon is called QViewer. In today’s post, we will go through some great use-cases for QViewer.   What is QViewer? QViewer is developed by Dmitry Gudkov, a friend of LivingQlik, a blogger in his own right over at BI Review, and a developer of tools like QViewer and EasyMorph. Dmitr ..read more