1 Reply Latest reply: May 14, 2018 11:47 AM by Youssef Belloum RSS

    Need to count values that are contingent on multiple variables

    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!