I have the fields below that return 'yes' if the patient met the criteria to fall in to one of the populations. I need to create a field to use in a patient detail table that will be one column but will say which population(s) the patient fell into so that I don't have all of these as columns. I had originally built a large if statement (also below) that was giving me the functionality I wanted but it doesn't work properly due to it not allowing patients to fall into multiple populations. I have since moved the if statement to the QVD builder and split it up to create these fields. What's the best way to achieve what I'm trying to accomplish?
