5 Replies Latest reply: May 25, 2018 1:29 AM by satish rathod RSS

    Including Values Intersecting to Selections in Filter of Qlik Sense.

    satish rathod

      Hello Everyone,

      I have the following Table :

       

      Name
      Adam
      Bob
      Charles
      Dean
      Danny
      Derrick
      Evan
      Kevin
      Liam
      Max
      Ryan
      Stan

       

      And i have the following Code :


      Table:

      LOAD

        Name,

          If(not WildMatch(Name,'D*'),'Exclude Initial D') as Name_Selection

      FROM Table_Names_Desc ;


      Concatenate(Table)

      LOAD

      Name,

          'Exclude Name' as Name_Selection

      FROM Table_Names_Desc

      Where Name <> 'Adam' and Name <> 'Kevin' and Name <> 'Ryan';


      Concatenate(Table)

      LOAD

          Name,

          'All Names' as Name_Selection

      FROM Table_Names_Desc ;

       

      So now if i select a Filter Pane "Name_Selection", I will have 3 selections:

      • Exclude Initial D.
      • Exclude Name.
      • All Names.

       

      So the issue that I am facing is that if I select Both 'Exclude Initial D' & 'Exclude Name',

      since there is nothing common between these values, it shows all the Names

      However i want it to show the Names Intersecting to both i.e. the values for the following selections should be

      • Exclude Initial D. : Adam, Bob, Charles, Evan, Kevin, Liam, Max, Ryan, Stan.
      • Exclude Name. : Bob, Charles, Dean, Danny, Derrick, Evan, Liam, Max, Stan.
      • Exclude Initial D. & Exclude Name. : Bob, Charles, Evan, Liam, Max, Stan. (Intersection of The Top 2 Selections).
      • All Names. : Adam, Bob, Charles, Dean, Danny, Derrick, Evan, Kevin, Liam, Max, Ryan, Stan.


      Also Check if the code is Working correctly or some changes are to be made to the code.


      Thanks in Advance.