Possible selections from a different field

[stevejones1]

Hi

I have 2 Fields,  Dim key and Source Key .. i have a search box on Source Key .. i want to display all the Source Keys associated with the same Dim Key .. as in the below example when user selects CDF , both CDF and LMN has to be selected because they share the same Dim Key .. how can i achieve this?

Dim  Key Source Key

4               CDF

4               CDF

4               LMN

4               LMN

1               ABC

1               ABC

Thank you!

[sunny_talwar]

Using set analysis, you can do this

{<[Source Key], [Dim Key] = p([Dim Key])>}

[stevejones1]

where should i use this ?

This is my expression for displaying the Source Key as a link in my table .. i dont have any other expression other than this one for my table ..

[Source Key]&'<URL>'&'https://abc/browse/'&[Source Key]

[stevejones1]

How do i enable the selections in the whole application ? i basically want to have this in field event triggers .. so that i select a source key from search box , which enables fields selection in dim key which triggers associated source keys .. is that possible?

[sunny_talwar]

May be like this

Only({<[Source Key], [Dim Key] = p([Dim Key])>} [Source Key]&'<URL>'&'https://abc/browse/'&[Source Key])

[stevejones1]

Using the above expression i am able to resolve the issue for one table but i have many charts .. so i am looking for a way to enable this through out the application.If thats not possible please suggest a way to do this individually for each chart.Attaching my application , search the value "QBO-174575" in the search .. you would be able to see 2 source jira keys associated with each other by one dim jira key .. in the table (screen shot below).. this specific key is open on 6/19 and closed on 7/6 ..so i want to display 6/19 in find vs fix chart .

Find on 6/19 and Fixed on 7/6 .. as of now only fix is display because i filtered on QBO - 174575

[stevejones1]

Is the below possible?