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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JasonMatney
Contributor
Contributor

How do I perform a Lookup with a variable in Qlik Sense?

I have a Lookup table that looks like this:

JasonMatney_0-1639070251375.png

And I am soliciting user input using a VizLib input form like this:

JasonMatney_1-1639070288506.png

I would like to pass the input responses to individual variables, then search for data in the Lookup table using those variables. For example, if the user inputs a response of $5.00 for "10. What is the CHP Fuel price, in $/MMBtu?", then I would like to assign 5 to a variable vCHPFuelPrice, then cross-reference the Lookup table using vCHPFuelPrice in order to calculate a result.

How would I do this in Qlik Sense?

 

 

 

Labels (1)
0 Replies