Where do you want to go?
Get Started
Online Courses

Axis Insights Blog / Data Model

by Mike Steedle, on Aug 21, 2016 11:00:20 AM

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 …

Read Story
Topics:PerformanceQlik SenseQlikViewData ModelLoad Script

by Jerry DiMaso, on Dec 29, 2014 10:07:28 AM

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 …

Read Story
Topics:Qlik SenseQlikViewBusiness IntelligenceData ModelLoad Script

by sreedy, on Nov 12, 2013 2:43:54 PM

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 …

Read Story
Topics:LOADQlikViewQVDData ModelExistsLoad ScriptOptimized

by Mike Steedle, on Jun 15, 2013 11:55:28 AM

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 …

Read Story
Topics:QlikViewData ModelLoad Script

by sreedy, on Jun 3, 2013 11:05:04 PM

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 …

Read Story
Topics:QlikViewData ModelLoad Script

by Mike Steedle, on Apr 27, 2013 9:44:54 AM

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 …

Read Story
Topics:QlikViewData ModelLoad Script

More...

Subscribe to Updates