2 Replies Latest reply: May 12, 2015 8:53 PM by Jonathan Poole RSS

    Filtering in Qlik Sense

    Laura Paviglianiti

      Hi -

       

      I have a listbox in Qlik Sense that lists out skills, so when I select a skill it gives me all of the people with that skill. I would like to be able to select multiple skills, so I find a person that has all my seleted skills. Currently when I select multiple skills, its giving me everyone who has at least one of the skills. How can I change the filter for me to give me only the people that meet all of the selected criteria in the listbox?

       

      Thanks!

        • Re: Filtering in Qlik Sense
          santhosh k

          You can create another field with all the combinations you require and then use the field as your selection box.

           

          Field 1           Field 2

          A                    GroupA

          B                    GroupA

          B                    GroupB

          C                    GroupA

          D                    GroupB

          A                    GroupC

          B                    CroupC

          C                    GroupC

          D                    GroupC

          • Re: Filtering in Qlik Sense
            Jonathan Poole

            There was a setting in QlikView called 'AND Mode' to accomplish this. Not there in Sense, but you can still use some expression work .  Here is  a sample that shows a chart

             

            No selections:

             

            Capture.PNG

             

            Selecting Skills A, B and C ... only User1 has all three (chart on top right uses AND mode)

             

            Capture2.PNG

             

            The chart expression for the 'and mode' chart is:

             

            if(getselectedcount(Skills)>0,

             

            count( distinct {<User={"=aggr(count(distinct Skills),User)=getselectedcount(Skills)"}>} Skills)

            ,

            count(distinct Skills)

            )