Set Analysis is one of the most powerful features since it allows you to create your own subset independent of current selections. Although Set Analysis syntax is somewhat intimidating for a new Qlik developer, once you master the syntax, it opens a world of possibilities for custom solutions. That said, for a long time, set...Continue Reading

Three important visualizations or data storytelling aspects are quality, quantity, and manner. Quality = Data Quality Quantity = Data Volume and Required Number of Fields Manner = Using the most appropriate chart form for compelling storytelling For data quality in QlikView or Qlik Sense application, as a Qlik developer, you have to pay attention to...Continue Reading

Picasso.js is an open source charting library to build custom, interactive visualizations using components. Components are visual building blocks to create custom charts. Two other important elements are scale and data. picasso.js charts can also be interactive and extensible. You can find many useful examples on picassojs.studio Butterfly Chart I am going to walk you...Continue Reading

Let’s face it — One of the facets of the fourth industrial revolution is the proliferation of data and the need for harnessing data for decision making. Much has been written by the likes of Dr. Edward Tufte and Stephen Few about effective data visualizations to empower organizations to know what’s happening and what needs...Continue Reading

Should a BI developer need to learn SQL(or not)? These invigorating questions would pass through your mind if you are into Business Intelligence, either you are interested or inclined to explore one? It would indeed be puzzling if you are asked to perform some queries with SQL from users to look at the data integrity...Continue Reading

Every year, Gartner publishes its annual business intelligence magic quadrant. Those of us passionate about Qlik anxiously await to see Qlik as a leader in the quadrant for the past six years. This simple yet effective visualization provides context that matters most to analyze data and gain insight from it. When it comes to data,...Continue Reading

I owe debt of gratitude to my friend, Dalton Ruer, for this blog post inspiration. He often writes about data context with his signature phrase — Context is King. That inspiration made me research useful functions that I can use for data brushing. Brushing is the process of interactively selecting data items from a visual representation....Continue Reading

CONCAT function is a lesser-known yet a powerful aggregation function. Since it is an aggregation function, you can use it in a Set Analysis expression. That opens up a world of possibilities for creative minds. In this blog post, I want to present a few good use cases to leverage the CONCAT function’s power. First,...Continue Reading

As you master QlikView or Qlik Sense, understanding how the script engine works under the hood will not only improve your ability to troubleshoot reload errors but also help you appreciate and marvel the power of the preceding load in your script. Let’s understand how the script load engine parses the script first. Then it...Continue Reading

If you are a Qlik developer, you know how to load data from Excel as it is a fairly straight forward process. But, what if you need to extract each sheet name as you load the respective table from Excel? Let’s explore the steps first. Load all tables first (All sheets within an Excel file)Loop...Continue Reading