Limiting results based on two values

[#1]

I have a table that contains the medications that patients are on.

I would like to give the end user the option to find patients that are on multiple medications. Meaning I want them to select from List 1 say "Aspirin" and in List 2 they choose "Ibuprofen". I want a table to then display those patients that are on both Aspirin and Ibuprofen.

[nagaiank]

One way of implementing this is using And-mode listbox.

I have attached an example.

Hope this helps.

[#3]

I never even noticed the AND for the list box.

I should have been more specific I'm using 2 list boxes because there are multiple choices they will make in each. Like "Aspirin 500 MG" "Aspirin TABLETS" as well as generics etc so no string partial or anything. So it would be more like ANY of the selections in List Box 1 AND then ANY of the selections in List Box 2.

[Miguel_Angel_Baeyens]

Hello,

You can use two modifiers in the set analysis of your expression, something like

Count({< Field1 = P(FieldInListbox1) > + < Field2 = P(FieldInListbox2) >} PatientID)

Not knowing your model better it's difficult for me to go further.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica