Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])
Great, thank you very much Gary!