DeepSee MDX Reference
FILTER
|
|
FILTER(set_expression, logical_expression)
SELECT MEASURES.[%COUNT] ON 0, FILTER(homed.city.MEMBERS, MEASURES.[%COUNT]>1150) ON 1 FROM patients Patient Count 1 Cedar Falls 1,188 2 Centerville 1,155 3 Cypress 1,221 4 Elm Heights 1,266 5 Juniper 1,197 6 Magnolia 1,156
SELECT MEASURES.[%COUNT] ON 0, FILTER(homed.city.MEMBERS, MEASURES.[%COUNT]>=0) ON 1 FROM patients Patient Count 1 Cedar Falls 1,188 2 Centerville 1,155 3 Cypress 1,221 4 Elm Heights 1,266 5 Juniper 1,197 6 Magnolia 1,156 7 Pine 1,139 8 Redwood 1,144 9 Spruce 1,135
SELECT MEASURES.[%COUNT] ON 0, FILTER(diagd.members, (MEASURES.[%COUNT]>500 and MEASURES.[%COUNT]<1000)) ON 1 FROM patients Patient Count 1 asthma 746 2 diabetes 555
SELECT homed.CURRENTMEMBER.PROPERTIES("Population") ON 0, FILTER(homed.city.MEMBERS,homed.CURRENTMEMBER.PROPERTIES("Population")>20000) ON 1 FROM patients ZIP 1 Cedar Falls 90,000 2 Centerville 49,000 3 Elm Heights 33,194 4 Redwood 29,192
SELECT {MEASURES.[%COUNT]} ON 0, FILTER(diagd.members, %SEARCH.&[[MEASURES].[age]<10]) ON 1 FROM patients Patient Count 1 None 8,425 2 asthma 703
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
|
Content for this page loaded from D2RMDX.xml on 2019-02-17 00:00:33
|