Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Modifying a dimension in master

I am fairly new to QLIK and have something I can not find out.

I have a database that has all the municipalities in the Netherlands with the number of inhabitants. I would like to make a dimension that only holds the municipalities that have more than 100.000 inhabitants. I think I need to use a set modifier but I can't find out how use these with dimensions instead of measures?

2 Replies
Employee
Employee

Re: Modifying a dimension in master

Method 1 - Script:

Load ... From Municipalities Where Inhabitants > 100000 ;

Method 2 - If statement in list box:

Aggr(If(Sum(Inhabitants)>100000, Only(Municipality)), Municipality)

Method 3 - Set analysis in list box:

Aggr(Only({1<Inhabitants={">100000"}>} Municipality)), Municipality)

HIC

Not applicable

Re: Modifying a dimension in master

Thnx! it works.

Martijn Kriens, Director Living Lab Amsterdam

Amsterdam Health & Technology Institute

Trinity Buildings, Building C

Pietersbergweg 17, Amsterdam The Netherlands

T: +31 20 566 7800*, *M: +31 6 43088338

*m.kriens@a <m.kriens@aiht.nl>hti.nl <http://hti.nl>, www.a

<http://www.aiht.nl/>hti.nl <http://hti.nl>*

Skype: martijn.kriens, Twitter: @martijnkriens

On Sun, Nov 16, 2014 at 8:54 PM, Henric Cronström <qcwebmaster@qlikview.com>

Community Browser