Gauge with fixed value

[Arild]

Hello,

I have a gauge that works fine, and I can select a country and it changes the value to match. 
However I would like to have 4 gauge that shows fixed calculations based on country. 

The formula I have today is: 

sum(Aggr(Sum(arr)*Num#(Liability),counterparty_name))

I have a field named: legal_entity (with 4 different options - NO, US, UK, DK)

How can I get my Gauge to show 4 different selection independently on the other selections in the model?

Thanks:-)

Arild

[Bill_Britt]

HI,

I would look at using set analysis, but normally the Gauge is dimenionless and it based on selection status. 

Bill

[vinieme12 · Accepted solution]

Example

sum(Aggr(Sum({<legal_entity={'UK'}>}arr*liability),counterparty_name))

Read more on set analysis here

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

[Arild]

Thanks:-)
Perfect