(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');

The Magic Of Set Analysis

Home/The Magic Of Set Analysis

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 [...]

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.