Set gauge value based on expression with where clause

[#1]

I have an excel dataset with location and value

Location, Value

Oven1, 101

Oven2, 150

Oven3, 125

I want to have a gauge for each location.

for the first guage:

Current = Value where Location = 'Oven1'

for the second guage:

Current = Value where Location = 'Oven2'

How do I do this with a non aggregate expression?

[#2]

Hi Jason,

Set Analysis will allow you to do this.  For example the formula to show values relating to Oven1 could be Sum({<Location={Oven1}>}Value).

I have attached a really simple example of how this could work in Qlik Sense.  Note the formula have been created as Master items.

Hope this helps.

Kind regards,

Rod