Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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