topic Calculates dimension set analysis or agg function in QlikView

Calculates dimension set analysis or agg function

Fri, 22 Oct 2010 17:01:45 GMT

Hey all,

I am wondering how to use a calculated dimensions, so instead of showing all regions, ex. :

Australia

Asia

West Europe

East Europe

it would show for example Australia, Asia, and West Europe together with East Europe as just Europe. Or just Australia and the rest of the world... I was searching a forum for that and trying to find a sollution but nothing works:(

I would appreciate your help,

Beata

Calculates dimension set analysis or agg function

pover — Fri, 22 Oct 2010 17:09:44 GMT

The calculated dimension would be something like the following:

if(match(Region,'West Europe','East Europe'),'Europe',Region)

However if you want something like this, it is better to create the group from the script as sometimes it is hard to sort calculated dimensions and the dropdown select doesn't work with calculated dimensions.

Regards.