Download Set Analysis Primer

x

Blog

Stay up to date with Qlik
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
Qlik scatterplot chart
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, context is king — Dalton Ruer. I wanted to walk you through how I created...
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. The original intention of brushing is to highlight brushed data items in different views of...
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, we will use the CONCAT function to include or exclude field values by triggering an...
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 will be easier to understand why preceding load comes handy when you create multiple transformations...
Continue Reading
1 2 3 8