04 May 2012

Qlikview: Calculated Dimensions 1: How to include a subset of a dimension in addition to dimension's itself

Once, I was asked to include 'European Union' total sales in a sales chart whose dimension was country field (i.e. only countries, there was no subset of countries like EU, BENELUX or NORDICS).

The solution included four elements:
  • A calculated dimension which was composed of country field +  'European Union' 
  • A variable to keep list of EU countries
  • A variable to keep the list of selected countries in the country field
  • An expression which could calculate total sales for country field and 'European Union' separately. 

The applied solution can be viewed in the qlikview application which can be downloaded from the following link:
https://sites.google.com/site/quickdevtips/home/CalcDim1.qvw



1 comment:

  1. Thanks Aydin, this is a great example!

    ReplyDelete