topic Re: Limiting results based on two values in QlikView

Limiting results based on two values

Tue, 28 Jun 2011 13:02:35 GMT

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.

Re: Limiting results based on two values

nagaiank — Tue, 28 Jun 2011 13:24:27 GMT

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

I have attached an example.

Hope this helps.

Re: Limiting results based on two values

Tue, 28 Jun 2011 13:43:34 GMT

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.

Re: Limiting results based on two values

Miguel_Angel_Baeyens — Tue, 28 Jun 2011 13:49:00 GMT

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