
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
'Not equal' mulitiple values in a Set analysis
I am trying to exclude a couple of values from a list within a set analysis - see attached example.
Can anyone help? This doesn't appear to work as I thought it would. There is Admit method has a long list of values and am tryong to avoid listing them in the analysis expression.
Thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This should have worked (even though it is showing the red line). But you can try this as well:
=Sum({<[Week Ending] = {'>=$(VwkEnd) <= $(VwkEndMax)'}, [Admit method] = e({<[Admit method] = {'GP Admission', 'Emergency Department'}>})>} Admissions)
Best,
S


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
=Sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"}> - <[Admit method]={'GP Admission','Emergency Department'}>}Admissions)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this...
=Sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"}, [Admit method]= {'*'} - {'GP Admission','Emergency Department'} >}Admissions)
If you will need insert a lot of fields in the Admit Method...you can load a XLS File with this fields linked to the data, so you can write:
Sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"}, [Include Admit method]= {'Y'} >}Admissions)
Your XLS file wil need two columns...[Admit method] and a column with a Y or N value. It will became easier to make adjust in the future.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help
