Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to include an average within a function MIN?

Hi, I have a question when trying to customize a measurement calculation chart.

Example: I have the following data table:

LeaderProjectPerformArchitecQAOperSecurity
Juan MendazAAA100%0%100%50%100%
Juan MendazBBB100%100%100%100%100%
Pablo PerezCCC100%0%100%100%0%
Karina UlloaDDD100%0%50%100%

100%

Karina UlloaEEE100%100%100%100%100%
Karina UlloaFFF100%100%100%50%100%

I need to calculate the minimum value for each leader and the average of each of the areas (Management, Architecture, Quality, Operations and Security) project, and I tried with this function:

Min(Aggr(Avg(Architec)avg(QA)avg(Perfom)avg(Oper)avg(Security),Leader)) but does not work in the chart, the chart included as measurement data does not recognize "the graph is not shown because it only contains undefined values."

Thank you help me shape the appropriate function for calculating I need in graph.

I'll be very greatful.

4 Replies
sunny_talwar

Can you try this:

RangeMin(Avg(Architec), Avg(QA), Avg(Perfom), Avg(Oper), Avg(Security))

Not applicable
Author

Tommy is perfect, thanks thousand!

sunny_talwar

Hahahaha how is tommy?

If you got what you were looking for, do you mind closing this thread down by selecting the correct answer.

Not applicable
Author

jajaja sorry Sunny <"the self-correcting">

Okay, I do right away!