Blog

/Blog/

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

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 Set Analysis Cheat Sheet

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

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

RightQlik: quick access to common operations on QlikView files

RightQlik is a simple custom context menu that’s shown when right clicking on a QVW file. This allows quick access to some common functions that a developer would often perform on a QlikView file.

By |2019-04-23T20:08:06-05:00March 24th, 2014|Development, Tools|20 Comments

QlikView 11 para Desarrolladores, ahora en español

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?

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

By |2017-05-23T10:56:34-05:00November 1st, 2012|QlikView 11 for Developers|19 Comments

Business is a Jeopardy! game

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

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

A New Choice of Armor: The Flag Matrix

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

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

Point In Time Reporting Out Of The Box

Today we continue with 'The Magic of Set Analysis' Series and, in this post I will share with you a "goodie". Something that has helped me speed up the Development process on new projects, and is specially useful when creating SiB's (Seeing Is Believing) or Prototypes for prospective clients, where the time is often short.

The Magic of Set Analysis – Point In Time Reporting

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

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.

Sign up to receive updates on new articles

x

If you like this article, consider subscribing to our mailing list to receive updates of new posts right in your email inbox