6 Replies Latest reply: Jul 14, 2017 7:45 AM by Victor Torres Jurado RSS

    Get dimension values not selected

    Victor Torres Jurado
    Victor Torres Jurado Jul 14, 2017 6:35 AM

      Hello Experts,

      I'm trying to display some data of a dimension that's not direct selected.

       

      Sample data:

       

      Data:

      LOAD * INLINE [

          Emp, Section, Project

          Emp 1, Section A, Project 1

          Emp 2, Section B, Project 2

          Emp 3, Section A, Project 3

          Emp 4, Section A, Project 4

          Emp 5, Section B, Project 5

          Emp 1, Section C, Project 6

          Emp 7, Section B, Project 7

          Emp 8, Section D, Project 8

          Emp 9, Section A, Project 9

          Emp 10, Section B, Project 10

      ];

       

      I get these data:

      Screen_01.png

      When I select some values from Section, I get:

      Screen_02.png

      Is there any way to show (in another object) the Employees that are not related to selected sections?.

      In this case they would be Employees 3, 4, 8 and 9


      PS: I'm using QlikSense Desktop 3.2 SR4


      Thanks in advance