Need to count values that are contingent on multiple variables
I'm having trouble finding the correct query to write in QlikSense that will provide me with what I'm looking for.
I have a list of patients (encounters) and a count of all of the medications (units_of_service) that they have received throughout their hospital stay; I also have each of those medications (description) divided up into drug class categories (AFHSDescription).
For example: If i filter down into two drug classes (AFHSDescription) I need to get a count of patients who had received medications in BOTH drug categories. Can someone please help with what query I would write in a Qliksense expression to provide the aforementioned request?