topic Re: KPI Chart not effected by filter selection in QlikView

KPI Chart not effected by filter selection

megan_deboer — Wed, 25 Nov 2020 16:16:04 GMT

I'm wondering if its possible to make a chart or KPI that won't be affected by any filter selection on the sheet? Is this possible?

Thank you! Megan

marcelviegas — Wed, 16 Aug 2017 20:11:24 GMT

Yes, it should follow the format below:
sum({1}field)

megan_deboer — Wed, 16 Aug 2017 20:15:05 GMT

Thanks Marcel!

I'm working on a calculation for the KPI: =(Sum([Cases-Verified:])/Sum([Cases-Total:]))

Where would I place the sum({1}field) within the formula?

Thank you!

silvacarlos — Wed, 16 Aug 2017 20:20:49 GMT

I think is

=(Sum({1}[Cases-Verified:])/Sum({1}[Cases-Total:]))

megan_deboer — Wed, 16 Aug 2017 20:23:25 GMT

Yes thats correct! Thank you!

marcelviegas — Wed, 16 Aug 2017 20:24:45 GMT

Right, did it work?

megan_deboer — Wed, 16 Aug 2017 20:25:56 GMT

Yes thank you!