link table to filter field

[#1]

Hello Everyone,

I have a filter field with a list of name and a table with some columns (another list of name and a measure that I calculate). I would like to link the 2. So, if I click on a name in the filter field, It displays some names of the table not all of the possible names.

I tried some expressions, 'if',  using the filter name but it doesn't work.

Does someone know if it is possible and how to do that ?

Regards,

Paloma

[ahaahaaha]

Hi Paloma,

Can you provide a small fragment of input data (a filter and a table) and what do you want to get as a result?

Regards,

Andrey

[devarasu07]

Hi,

Can you share your mock data with expected output?

are you looking something like this?

map1:

mapping LOAD *

Inline [

CCode, Country

Sw, Sweden

Dk, Denmark

No, Norway

] ;

Salespersons:

LOAD *,

ApplyMap('map1', CCode,'Rest of the world') As Country

Inline [

CCode, Salesperson,Sales

Sw, John,100

Sw, Mary,200

Sw, Per,300

Dk, Preben,500

Dk, Olle,600

No, Ole ,700

Sf, Risttu,900] ;

Drop Field 'CCode';

o/p

[#4]

Hello,

I can not provide my data but if we are looking at those provide by Devarasu R.

My filter field will contain : Sweden , Denmark and Norway. and if I choose Sweden,  in my table I want to display information about John and Per and not about John, Per and Mary.

[#5]

Thank you what you said could help for other things but it is not what I want to do here.

[devarasu07]

Hi,

Can you share your sample data with expected output screen image. Thanks

[#7]

Like I said to Andrey I can not provide my data  but if we are looking at your data.

My filter field will contain : Sweden , Denmark and Norway. and if I choose Sweden, in my table I want to display for example information about John and Per and not about John, Per and Mary.

[devarasu07]

Hi,

Based on the mock data, it will show John, Per and Mary. how your expecting to show only John and Per ?

do you have any calculated conditions to exclude (mary) values?

Thanks,
Deva

[#9]

Yes sorry I forgot to explain. I will use ID.

For example,

Person :

CCode, Name, ID

Sw, John,1

Sw, Mary,2

Sw, Per,1

Dk, Preben,4

Dk, Olle,5

No, Ole ,6

Sf, Risttu, 7

Country :

CCode, Country

Sw, Sweden

Dk, Denmark

No, Norway

So Country and Person are linked with CCode.

My filter field : Sweden , Denmark and Norway

My table : Names

So for example, if I click on Sweden from my filter field, I would like to display, in my table, names where id is like 1.

I don't know if it is very clear.

[OmarBenSalem]

You can for example select only the min (ID) per country to show:

That would be:

measure: sum({<ID={"=aggr(min(ID),Country)"}>}Sales)

See the attached app: