Aggr function with sum if condition in qlivview

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I just have a hurdle that is driving me crazy. I would like to create a gauge that has simple structure.

=min({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) - lower bound

=max({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) - upped bound

and the bounds in the middle like

=max({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) * 0.2

=max({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) * 0.4 etc

I am after checking certain person performance vs all. However, I missed to noticed that the Nbr of Orders refers to several KPIs and I am after a certain KPI only.

How can I restrain it to show me the info for only 1 KPI

This formula below simply does not work:

=max({<Names=>}total aggr(avg({<KPI = {'DesiredKPI'}>}{<Names=>}[Nbr of Orders]),Names))

topic Aggr function with sum if condition in qlivview in QlikView

Aggr function with sum if condition in qlivview