Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr function with sum if condition in qlivview

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))

0 Replies