Get dimension values not selected

[_k0zm0_2]

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:

When I select some values from Section, I get:

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

[kaushiknsolanki]

Hi,

Create a table Object and put all dimensions and put expression as below.

Sum({1-$}1)

Regards,

Kaushik Solanki

[_k0zm0_2]

Thanks for your answer kaushik.solanki

Your solution almost fits, but I get the Employee 1, that is in 2 sections (A and C -selected-)

Is possible that Employee 1 doesn't appears?

Thanks in advance

[kaushiknsolanki · Accepted solution]

Try this.

Sum({<Emp = e(Emp),Section=>}1)

Regards,

Kaushik Solanki

[_k0zm0_2]

perfect!

Thank you very much kaushik.solanki!

[vinieme12]

or if you need just a listbox of excluded values then try below

AGGR(ONLY( {1-$} Employee),Employee)

[_k0zm0_2]

Wow!

This is even better! Thank you vinieme12!