topic Re: Retaining a KPI value after filtering in QlikView

Retaining a KPI value after filtering

stunelson — Wed, 16 Jan 2019 14:15:12 GMT

Hi, fairly new to QlikSense so any help would be appreciated. I have a KPI which is counting the number of active services for a specific Customer, in this case the result is 14. I also have a chart which allows me to filter the Services, when I do this the KPI updates to reflect the number of Services selected. I need to ensure the original value (14) is retained.

The expression in the KPI is:

=Count( {$<[SERVICE_STATUS] = {'Active'}>}Distinct Service_Number)

I think I need to somehow incorporate the Customer using the "only" expression but not sure how?

Re: Retaining a KPI value after filtering

sunny_talwar — Wed, 16 Jan 2019 14:26:03 GMT

Try this

=Count({1<[SERVICE_STATUS] = {'Active'}>} DISTINCT Service_Number)

Re: Retaining a KPI value after filtering

stunelson — Wed, 16 Jan 2019 14:28:47 GMT

Hi Sunny,

This is giving me the count of Services across the dataset as opposed to a specific Customer.

Re: Retaining a KPI value after filtering

sunny_talwar — Wed, 16 Jan 2019 14:30:57 GMT

I guess ignore selection in Service field in that case

=Count({$<[SERVICE_STATUS] = {'Active'}, Service>} DISTINCT Service_Number)

Re: Retaining a KPI value after filtering

stunelson — Wed, 16 Jan 2019 15:02:16 GMT

This now takes me back to my filtered count.

I was trying something like this but the expression is not quote correct:

=only({<Customer={1}>}count(SERVICE_STATUS={'Active'}>}Distinct Service_Number))

Re: Retaining a KPI value after filtering

sunny_talwar — Wed, 16 Jan 2019 15:00:17 GMT

I don't think I follow... would you be able to share a sample where I can see the issue??