topic Set gauge value based on expression with where clause in App Development

Set gauge value based on expression with where clause

Wed, 08 Apr 2015 20:14:05 GMT

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?

Wed, 08 Apr 2015 22:05:53 GMT

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