Fixed parameters despite the filter

[mpelliciari]

Good morning,

I'm a newbie on Qlik Sense.

I'm looking to create the following measure to evaluate our commercial performance index, that must be indipendent of any further parameter used as filter.

I got 4 columns:

- PROPOSAL (ABC)

- COMPANY (US, ME, EU)

- VALUE (##)

- SIGNED (yes/null - if proposal became agreement/if proposal not became agreement)

I'd like to evaluate the success performance, calculated as:

= (Sum of every value where [SIGNED] = 'yes') / (Sum of every [VALUE])

Said PERFORMANCE INDEX values should be indipendent of SIGNED parameter (yes/no) in the sheet, because I have other visualizations that are based on SIGNED parameter.

If I should select SIGNED = 'yes' only visualizations would change, not PERFORMANCE INDEX values. Someone can help me with the formula? 

Thank you in advance for your time

[GaryGiles · Accepted solution]

To ignored all other potential filters, you would use 1 as you identifier.

sum({1<[SIGNED]={'Yes'}>} [Value]) / sum({1} [Value])

To only ignored selections made on the SIGNED field, but accepting other filters, you would use:

sum({$<[SIGNED]={'Yes'}>} [Value]) / sum({$<[SIGNED]=>} [Value])

[mpelliciari]

Great, thank you very much Gary!