Skip to main content
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