A way to show alternative/excluded values

[OmarBenSalem]

Hi all,

Is there a way/ a direct function to show the alternative/excluded values?

if I have 4 dates for example, and a field containg 100 values;

if I select date1;

count(Field) will be 80

if I want to show these 80 fields; I'll just have to use ; concat(Field,',') for example

but what if I wanted to show the 20 excluded fields??

There is the GetExcludedCount function to return thenumber which is 20; but how to show these 20 values?

Thanks

[sunny_talwar]

One way (not direct) is to use this

Concat({<Field = e(Field)>} Field, ', ')

[stigchel]

concat({1-$}Field,',')

From the help for set Analysis

Examples:

sum( {1-$} Sales )
returns sales for everything excluded by the current selection.

[OmarBenSalem]

that did not do it:

expression used:

Concat(distinct {<[WS.Currency] = e([WS.Currency])>} [WS.Currency], ', ')

[OmarBenSalem]

I already tried such a thing and it returned all the 147 values (don't know why):

see:

[sunny_talwar · Accepted solution]

Try stigchel‌'s way or try this

Concat(DISTINCT {1<[WS.Currency] = e([WS.Currency])>} [WS.Currency], ', ')

[OmarBenSalem]

Brilliant as usual

[OmarBenSalem]

I have yet another question

I have this table:

which contains currency list by date

in total there is 176 currencies; what If I wanted to show, not the list of currencies that exist in each date, but the list of those that does not (without selecting any date)

sthig like we were doing but directly within this table

[sunny_talwar]

So, you mean to show which currency don't exist on a particular day?

[OmarBenSalem]

Yes ! with the previous expression; we'll have to select a date to show the currencies that do not exist

I want to show them in a table with the date as a dimension