topic set analysis exclude variable in QlikView

set analysis exclude variable

NickHoff — Fri, 24 Jun 2016 19:28:35 GMT

Hello,

I have the following set:

COUNT({1<FinancialClassCode ={"1"}, DRG = $::DRG, Facility = $::Facility, CalendarQuarterYear = $:: CalendarQuarterYear, CalendarMonth = $:: CalendarMonth, JointSurgeonName -= {'$(vExcludeSurgeon)'}>}DISTINCT PatAcctNum)

I'm looking to ignore all selections except the following above. I added the -= {'$(vExcludeSurgeon)'} which is supposed include all Surgeons except the excluded surgeon defined by GetFieldSelections(JointSurgeonName).

However, the set isn't working correctly and it's still counting the excluded surgeon..

Re: set analysis exclude variable

sunny_talwar — Fri, 24 Jun 2016 19:31:15 GMT

Can you try this:

Count({1<FinancialClassCode ={"1"}, DRG = $::DRG, Facility = $::Facility, CalendarQuarterYear = $:: CalendarQuarterYear, CalendarMonth = $:: CalendarMonth, JointSurgeonName = e(JointSurgeonName)>}DISTINCT PatAcctNum)

Re: set analysis exclude variable

NickHoff — Fri, 24 Jun 2016 19:34:38 GMT

thanks Sunny

Re: set analysis exclude variable

sunny_talwar — Fri, 24 Jun 2016 19:35:09 GMT

No problem at all... I am glad I was able to offer help