I need to be able to filter patients based on if they ever had a certain type of value in their past, not whether they currently do. Here is some sample data. I would like to have this done in the GUI and not within the script since I need the rest of the data for other analyses.
The result should return all rows for the first two patients and nothing for the last one if they ever had an Evaluation.
Use two listboxes. One for Visit Type and one for MRN_ID. Then select Eval in the Visit Type listbox. Next right click the MRN_ID listbox and choose the Select Possible option from the context menu. Finally right click the Visit Type listbox and choose the Clear option from the context menu.