Tag Archives | QlikView

Information pertaining to QlikView solutions

Qlikview Set Analysis Guide III – Alternate States

In this article I will explain how to use alternate states* functionality within set analysis. Alternate states is a new feature available in QlikView 11 and allows for objects in the document to only react to other objects that are set to the same state.  This allows for easier comparative analysis. Incorporating alternate state logic […]

Continue Reading

Qlikview Set Analysis Guide II –User Control

In this article I will discuss how to use dollar sign expansion with variables and dollar sign expansion with expressions within the context of set analysis. In my previous article, Qlikview Set Analysis Guide, I discussed basic set analysis. Identifiers, operators, and modifiers are all the tools you still need but there are other items […]

Continue Reading

Qlikview Set Analysis Guide

Out of the box, QlikView expressions aggregate values for the current set of selections. However, to compare sets of records in the same chart or on the same tab, either you need to prepare the data in the load script, hard-code the expressions you use, or use set analysis. The option with the most flexibility […]

Continue Reading

Using Joins in QlikView

SQL developers share the common experience of joining related tables in order to retrieve data sets.  The same holds true when working with data in QlikView.  For those with a SQL background, the syntax for joins in QlikView are slightly different and can be a bit disconcerting when they are used.  It’s easy to scratch […]

Continue Reading

Qlikview Dimension Limits

Dimension Limits are new within Qlikview 11. They are used to define filters that establish how much information to return and how to organize it within a chart. The new ‘Dimension Limits’ tab is now available on all chart types except the Gauge Charts and the Pivot Tables. Within the Dimension Limits tab, three selection […]

Continue Reading