Qlik Community

Qlik Sense App Development

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

Not applicable

Set gauge value based on expression with where clause

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?

1 Reply
Not applicable

Re: Set gauge value based on expression with where clause

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

Community Browser