Axis Insights Blog / Data Model

DID YOU KNOW? Several years ago, I discovered that joining to a resident table in QlikView causes the resulting table to be ordered by the key field, in that field's …

Stephen Redmond is a QlikView expert, as indicated by his book Mastering QlikView in which he clearly illustrates myriad advanced techniques from data modeling and performance tuning to expression writing …

As far as I know the Exists() function, in its simplest form ( Exists([Field]) ), is the only WHERE clause you can include when loading from a QVD that will …

In building applications, a field is often encountered that does not natually sort in the desired order, alphabetically or numerically. The most frequent occurrence of this I have seen is …

The purpose of this post is to provide some permanent notes we can refer to about hierarchies in general and more specifically about the Hierarchy() and HierarchyBelongsTo() loads in QlikView …

Something that would be nice to see in QVW log files is the number of rows that result from executing a join. It would be useful to test assumptions about …