Group List Box

jlampard40 — Fri, 15 Nov 2024 23:57:44 GMT

Hi - I'm trying to create a new list box to select, based on different criteria. The criteria are diagnostic scanners - however, I need some of the criteria to also be based on other criteria, not just on room alone. For example CT in house is based on the same scanner / room criteria as CT Inpatient BUT I also need CT Inpatient to also be based on 'Inpatient' field only. CT Inhouse grouping includes ALL patient types so is OK to leave as it is.

So, how can I add multiple set analysis type crtieria to my match statements to also add other criteria as a match? Many thanks:

=If(Match([Room], 'CTMOB', 'CTMOB2', 'CSPI', 'CNUF', 'PETCT'), 'CT External',

If(Match([Room], 'MOBMR', 'RMR2', 'MSPI'), 'MR External',

If(Match([Room], 'OCT', 'SBS', 'SCS2', 'SCSU'), 'CT In-house',

If(Match([Room], 'SMR1', 'SMR2', 'SMR3', 'SMR4', 'SMR5', 'SNWMR'), 'MR In-house',

If(Match([Room], 'OCT', 'SBS', 'SCS2', 'SCSU'), 'CT Inpatient',

If(Match([Room], 'SMR1', 'SMR2', 'SMR3', 'SMR4' , 'SMR5' , 'SNWMR'), 'MR Inpatient',

If(Match([Room], 'SCSU', 'SCS2', 'SMR4' , 'SMR3'), 'ED'),

))))))

Re: Group List Box

sunny_talwar — Thu, 17 Sep 2020 13:42:11 GMT

Not entirely sure what needs to be added, but you should be able to add and or conditions to your if statement

topic Group List Box in QlikView

Group List Box

Re: Group List Box