topic Re: 'Not equal' mulitiple values in a Set analysis in QlikView

'Not equal' mulitiple values in a Set analysis

Thu, 05 Mar 2015 13:05:01 GMT

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

Re: 'Not equal' mulitiple values in a Set analysis

sunny_talwar — Thu, 05 Mar 2015 13:09:32 GMT

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,

Re: 'Not equal' mulitiple values in a Set analysis

terezagr — Thu, 05 Mar 2015 13:11:55 GMT

Try this:

=Sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"}> - <[Admit method]={'GP Admission','Emergency Department'}>}Admissions)

Re: 'Not equal' mulitiple values in a Set analysis

Thu, 05 Mar 2015 13:57:59 GMT

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.

Re: 'Not equal' mulitiple values in a Set analysis

Fri, 06 Mar 2015 09:10:25 GMT

Thank you for your help