Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: how to include an average within a function MIN?

Can you try this:

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

Not applicable

Re: how to include an average within a function MIN?

Tommy is perfect, thanks thousand!

Re: how to include an average within a function MIN?

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

Re: how to include an average within a function MIN?

jajaja sorry Sunny <"the self-correcting">

Okay, I do right away!

Community Browser