Get Alternative Field Value

[livio218526]

Hello to all,

I need to show in a table (or otherwise store on one side).

That is, selecting one or values in a Filter pane, I would like to have a column with alternative values (in light gray).

For example:

Thanks,

Livio

[YoussefBelloum]

Hi,

do you mean transform POSSIBLE VALUES to EXCLUDED VALUES ? because light grey on qlik means EXCLUDED VALUES

[livio218526]

I want get Alternative value in a table.

For example: SPAIN,UK and USA.

[YoussefBelloum]

Ok

make your selection on the first filterbox, on the second filterbox try this as an expression:

=aggr(Only({<Country=E(Region)>}Region),Region)

[livio218526]

Sorry but i don't understand. I have only 1 dimension. There you are using 2 fields.

[YoussefBelloum]

My bad, I was testing it and I forgot to replace all the fields using your field

here you go:

=aggr(Only({<Region=E(Region)>}Region),Region)

[pablolabbe]

Create a second filter panel and add the expression as Dimension instead of selecting an existing field or dimension.

[livio218526]

I have already tried this expression, but it doesn't work.

The result is the current selection and not the alternative values.

[YoussefBelloum]

something is wrong then because it is a tested solution

[YoussefBelloum]

would you be able to share sample qvf app ?