(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.data-privacy-src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-63488605-1', 'auto'); ga('send', 'pageview');

Miguel Ángel

Home/Miguel Ángel García

About Miguel Ángel García

I have worked with Qlik tools for 10+ years and implemented BI solutions at multiple customers across a variety of industries. I’m author of the book QlikView 11 for Developers (several editions) and blogger at AfterSync (a.k.a. iQlik). I'm also the author of the Lean Data Processing online course, focused on building optimized data pipelines in QlikView and Qlik Sense.

A New Choice of Armor: The Flag Matrix

By |2017-05-23T10:56:34-05:00May 22nd, 2011|Data Model|

As you know already, I'm a big fan of using Set Analysis in my QlikView applications, especially for Point In Time Reporting. However, there might be some specific situations in which Set Analysis just won't cut it and you need an alternative... Continue Reading to discover it! (Demo Script included...)

The Magic of Set Analysis – Point In Time Reporting

By |2019-07-15T11:00:19-05:00November 27th, 2010|Set Analysis, The Magic Of Set Analysis|

I have always believed that Set Analysis' Raison d'être is to satisfy a basic need in any BI Tool: the ability to perform "Point In Time" Analysis. But, needless to say, it is also amazingly useful for the fulfillment of a bunch of other special needs. In this post, I will cover the specifics of Point In Time Reporting with Set Analysis.

The Magic of Set Analysis – Part III

By |2019-05-25T16:30:50-05:00November 21st, 2010|Set Analysis, The Magic Of Set Analysis, Uncategorized|

In Part II of The Series, I wrote about the general syntax of a Set Expression and provided some basic examples using Set Modifiers with explicit field value definitions. Now, our next step will be about making our desired record set dynamic and based on the user's current selections, that is, using an Implicit field value definition.

Reading iPhone’s Database

By |2017-05-23T10:56:38-05:00September 26th, 2010|Personal Use, Random|

This week's post is really not something you will come accross when developing a business application with QlikView, but rather it is a bit random, and somwhat fun. We will go through the required steps to read data stored in your iPhone, such as Call History, SMS Messages, Contacts list, Notes, etc.