topic Re: Get dimension values not selected in App Development

Get dimension values not selected

_k0zm0_2 — Fri, 14 Jul 2017 10:35:54 GMT

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

Re: Get dimension values not selected

kaushiknsolanki — Fri, 14 Jul 2017 10:48:35 GMT

Hi,

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

Sum({1-$}1)

Regards,

Kaushik Solanki

Re: Get dimension values not selected

_k0zm0_2 — Fri, 14 Jul 2017 11:00:29 GMT

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

Re: Get dimension values not selected

kaushiknsolanki — Fri, 14 Jul 2017 11:16:21 GMT

Try this.

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

Regards,

Kaushik Solanki

Re: Get dimension values not selected

_k0zm0_2 — Fri, 14 Jul 2017 11:20:24 GMT

perfect!

Thank you very much kaushik.solanki!

Re: Get dimension values not selected

vinieme12 — Fri, 14 Jul 2017 11:26:12 GMT

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

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

Re: Get dimension values not selected

_k0zm0_2 — Fri, 14 Jul 2017 11:45:40 GMT

Wow!

This is even better! Thank you vinieme12!