Skip to Main Content
QlikView for Developers Cookbook
book

QlikView for Developers Cookbook

by Stephen Redmond
June 2013
Beginner to intermediate content levelBeginner to intermediate
290 pages
4h 59m
English
Packt Publishing
Content preview from QlikView for Developers Cookbook

Using alternate states with Set Analysis

The alternate states function was introduced to QlikView in version 11. It allows us to create a named set of selections separate to the default current selections. At a simple level, this allows us to create a side-by-side analysis to allow us to easily and quickly compare one set of selections versus another. At a more complex level, it opens up a wide range of analysis possibilities.

In this recipe, we will create two states and look at how we access those states in the Set Analysis syntax.

Getting ready

Load the following script:

LOAD * INLINE [ Country, City, Year, Sales USA, San Francisco, 2011, 1245 USA, San Francisco, 2012, 3322 USA, San Francisco, 2013, 3245 USA, New York, 2011, 2765 USA, New York, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

QlikView for Developers

QlikView for Developers

Miguel Angel Garcia, Barry Harmsen
QlikView 11 for Developers

QlikView 11 for Developers

Miguel Angel Garcia, Barry Harmsen

Publisher Resources

ISBN: 9781782179733Other