Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

_k0zm0_2
New Contributor III

Get dimension values not selected

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

Tags (1)
1 Solution

Accepted Solutions

Re: Get dimension values not selected

Try this.

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

Regards,

Kaushik Solanki

6 Replies

Re: Get dimension values not selected

Hi,

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

Sum({1-$}1)

Regards,

Kaushik Solanki

_k0zm0_2
New Contributor III

Re: Get dimension values not selected

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?

Screen_03.png

Thanks in advance

Re: Get dimension values not selected

Try this.

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

Regards,

Kaushik Solanki

_k0zm0_2
New Contributor III

Re: Get dimension values not selected

perfect!

Thank you very much kaushik.solanki!

vinieme12
Esteemed Contributor II

Re: Get dimension values not selected

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

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

_k0zm0_2
New Contributor III

Re: Get dimension values not selected

Wow!

This is even better! Thank you vinieme12!

Community Browser