Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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>