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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
riho92qv
Contributor III
Contributor III

How to return the value of one field that matches the value of another field

Hi
i have 2 fields FileName and FileURL. 
I want to create controls that call the URL of the corresponding file depending on the title on the button. So it is necessary to match the title of the Button with the URL in the second field. titles and URL are in one match.I will add a simplified example. Is there any way to solve this using setanalysis. 

How can I automatically find the connection so that depending on the General-Text field the Action-Application field changes so that I can call the url of the corresponding file with the press of a button.
Riho

Labels (1)
1 Reply
riho92qv
Contributor III
Contributor III
Author

Hi
I think I found a solution myself

=Aggr(Only({<[Name]={['Header 1']}>}[URL]) , [URL])

 

Riho