Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Group List Box

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'),


Labels (4)
1 Reply

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