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

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

Most of us who have worked with both QlikView and Qlik Sense is aware of various aggregate functions that we can use in the script as well as charts. The family of functions known as aggregation functions consists of functions that take multiple field values as their input and return a single result, where the...Continue Reading