(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.

Of Dashcards and Drill-Down Maps

By |2020-07-24T07:28:03-05:00July 23rd, 2020|Data Discovery, Data Visualization, Development|

In the world of Data Visualization, context is King. Context helps build understanding. With a demo of an interactive dashboard, I intend to present an example of how adding context to a visual helps paint a more accurate representation of the performance being measured.

QVD Segmentation 2.0 – Speeding Up QVD Partitioning by up to 5x

By |2020-03-19T12:47:31-06:00September 30th, 2019|Development, Lean Data Processing, Optimization, Qlik Sense, QlikView, Tools|

One of the tools I’ve developed as part of the Lean Data Processing Framework is an optimized implementation of the QVD Segmentation technique. This technique is typically used in Qlik Deployments that deal with large datasets, and allows us to split a large table into multiple QVD files. For example, storing one QVD for each month of data, rather than storing the entire dataset in a single file. While this technique has always been around, and other implementations exist that perform the same operation, the modified version that I’m sharing today focuses on reducing the time it takes for the process to complete by avoiding over-processing, and reducing the motion of data required in the process.

[VIDEO] Incremental Data Extracts with Qlik using Delta Tags and QVD Segmentation

By |2020-03-19T12:46:40-06:00May 27th, 2019|Data Strategy, Delta Tags, Development, Incremental Loads, Lean Data Processing, Tools|

The following 14-min video shows how the Delta Tags technique easily replaces another commonly used approach to incremental loads (based on variables) in QlikView and Qlik Sense, and demonstrates why the Delta tags approach makes the process more reliable while still being highly efficient and configurable. Another important aspect of this technique that is demonstrated in the video is how the Delta Tags approach works very well with segmented QVDs (a.k.a partitioned QVDs) in an incremental scenario, something that is not as straightforward to implement with other approaches.

Enhancing Your Data Strategy on Qlik Projects With the Lean Data Processing Paradigm

By |2020-03-19T12:46:17-06:00May 21st, 2019|Data Strategy, Development, Incremental Loads, Lean Data Processing|

One of the major themes in last week’s Qonnections event in Dallas, TX, was the importance of having a solid Data Strategy in conjunction with a good Analytics Strategy to build and support a robust Data Platform that not only enables but also nurtures a Data Literacy culture within a company. This focus on the [...]

Delta Tags – A new mechanism for efficiently keeping track of incremental reloads in QlikView and Qlik Sense

By |2020-03-19T12:45:08-06:00April 23rd, 2019|Development, Lean Data Processing, Optimization, Tools|

When working with large datasets in QlikView and Qlik Sense, it’s important to ensure the backend data processing jobs (Extracts and Transforms) perform efficiently, by following best practices to reduce execution time and keep resource usage at a minimum. One of the best practices recommended for efficient data processing is implementing an incremental load strategy, [...]

The QlikView and Qlik Sense Set Analysis Cheat Sheet

By |2019-05-25T16:27:53-05:00June 22nd, 2015|Set Analysis, The Magic Of Set Analysis|

This time, I’m sharing with you a “QlikView Set Analysis Cheat Sheet”. A resource that I hope you can use as reference when struggling with set analysis expressions and as a quick guide to discovering the full power of set analysis.

Keep Calm and QlikOn! – Announcing the launch of our QlikView Online Training Center

By |2017-05-23T10:56:34-05:00March 24th, 2014|Set Analysis, The Magic Of Set Analysis|

We’re lunching an Online Training Center, a place where QlikView users, developers and enthusiasts can share and learn new skills with top-quality QlikView courses. Our first course will be about Set Analysis, and will be delivered in English and Spanish (in separate sessions) by my colleague Barry Harmsen and myself, respectively. Please join us next Friday [...]

QlikView 11 para Desarrolladores, ahora en español

By |2017-05-23T10:56:34-05:00December 6th, 2013|Development, QlikView 11 for Developers|

Me llena de orgullo y satisfacción anunciar la publicación de la versión en español de nuestro libro QlikView 11 para Desarrolladores, el cual es una traducción del libro publicado originalmente en inglés y escrito junto con Barry Harmsen. Este trabajo es fruto de un esfuerzo de varios meses y cuya motivación surge del gran recibimiento que la comunidad QlikView dio a la versión original. ¡Ingresa para más información!

QlikView 11 for Developers: What’s Inside?

By |2019-05-25T16:29:38-05:00November 1st, 2012|QlikView 11 for Developers|

It is with great excitement that I post this announcement to let you know a bit more about the "QlikView 11 for Developers" book that my friend Barry and I have co-authored.   As you may already know from our initial announcement, the book will officially be released around November 15th (though you can submit [...]

Business is a Jeopardy! game

By |2017-05-23T10:56:34-05:00August 20th, 2012|Data Discovery|

Answers. Only those that have them keep on playing the game. Moreover, those that ask the right questions will always stay in advantage. Everyone that has played any trivia game knows that having the right answers is not an easy feat, but if you've played Jeopardy! you'll know that it is even harder to turn [...]

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...)