1 Reply Latest reply: Jul 30, 2018 3:04 PM by Rob Wunderlich RSS

    How to implement AND logic between two dimension values in QLikSense

    Vijayanth Radha

      When we select multiple filters in QlikSense filters, they work like an OR condition. How to design a filter which will ONLY return records where the selected dimensions all exist together.

       

      For example consider the below data:

       

      Patient IDIssue
      101Fever
      101Headache
      101Pain
      101Weight Gain
      101Nausea
      102Fever
      102Headache
      102Pain
      103Fever
      103

      Pain

       

      When I select Fever AND Headache I only want to see patient id 101 and 102.

       

      By default if I select these two values, I will get all these ids, I ONLY want where the two dimension values exist together for an ID.