Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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