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]

try this please and let me know (make sure that field name is correctly written and make sure to use a filterbox as object, textbox will require another expression):

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

[livio218526]

i don't know.

I use this expression to create a dimension on a table

[livio218526]

I try but not woking.

[YoussefBelloum]

take a look:

[livio218526]

Sorry but I'm not understanding Once you select a prompt value, I would like to have the same dimension values in a table, so you can add more information.

[YoussefBelloum]

Ok I got it, I thought you were using a second listbox to list the excluded values, the expression I gave works only on a listbox

I think this will work perfectly on a table:

=Only( {$<Region= E({1<Region={"$(=getfieldselections(Region))"}>})>} Region)

[livio218526]

Sorry, but not work again

[YoussefBelloum]

create sample app with the same issue and share it with us

[livio218526]

How I can add the file qvf here?

[YoussefBelloum]

you should use the "advanced editor" like described in this topic

How to attach a file on qlik community discussion