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 syntax resided within the aggregation function. That aspect of set syntax constrained the re-usability of...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 subset ratio and information density. Let’s start with the subset ratio. Since a key field...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 through the steps to create a Butterfly chart in Qlik Sense using picasso.js. I stumbled...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 to be done to stay competitive. One of the aspects of effective data visualizations is...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 which acts like adding more flare to it. THE JOURNEY If you are going through...Continue Reading
