Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
stevejones1
Contributor III
Contributor III

Possible selections from a different field

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!

6 Replies
sunny_talwar

Using set analysis, you can do this

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

stevejones1
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

2017-08-08_21-11-24.jpg

stevejones1
Contributor III
Contributor III
Author

Is the below possible?