topic Re: Modifying a dimension in master in Qlik Learning Discussions

Modifying a dimension in master

Sat, 15 Nov 2014 13:09:13 GMT

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?

Re: Modifying a dimension in master

hic — Sun, 16 Nov 2014 19:54:00 GMT

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

Re: Modifying a dimension in master

Mon, 17 Nov 2014 06:58:06 GMT

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>