How to calculate the invert selection of a current selection

[uacg0009]

Hi all,

I have data below:

And I also have a list of ITEM, and what I want to calculate is :

If I choose B and C, I want to calculate what other ITEM the ID who buy ITEM B and C buy?

In this example, it should output

1 A 2

2 D 1

Do you have any ideas?

Thank you!

[vikasmahajan]

Try this approach

Start with a blank table | QlikCommunity

Vikas

[vikasmahajan]

There could be 2 ways to solve your problem:

1. Show/Hide the table chart based on the current selection count (you can use GetFieldSelections to find that)

2. Have a calculated dimension based on GetFieldSelections, which would return a NULL when no selections are made, and 'Suppress when Value is Null' option selected for the dimension

Please go through 2 approach.

Vikas

[bruno_m_santos · Accepted solution]

Try

sum( {$<ITEM = ITEM >} QTY )  Current Selections

sum( {$<ITEM =- ITEM >} QTY )  Exclude Current Selections

Thanks

Bruno