Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
zach_paz
Contributor III
Contributor III

Using a variable input field value to return the corresponding value of another field

HI!

I've searched the forums to solve this question, but cannot seem to get it working. Your help is much appreciated!

I have two fields with the following values:

CodeCode Name
1Car
2Bus
3

Plane

 

I would like to use an input field value to designate the code. In this case, the variable is called "vCode". I would like to return the corresponding field value for what matches the "vCode" input field box.

Input Field Value: "vCode"= 2

Result:  Text Box: Bus

This would be similar to a vlookup in excel.

Thanks in advance!

Zach

Labels (4)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

You can achieve it using set analysis 

Only({< Code = {'$(vCode)'}>} [Code Name])

View solution in original post

3 Replies
Vegar
MVP
MVP

You can achieve it using set analysis 

Only({< Code = {'$(vCode)'}>} [Code Name])

zach_paz
Contributor III
Contributor III
Author

Works great. Thank you very much!

taml
Contributor II
Contributor II

Thanks @Vegar  for the solution and @zach_paz  for pitching a perfect question.