0 Replies Latest reply: May 14, 2018 11:01 AM by Christina Scolieri RSS

    Count number of times a variable meets several requirements

    Christina Scolieri

      Hi All,

       

      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?


      Thank you so much!