Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get Min() value by dimension in KPI

Hi,

I have some Master Item measurement, witch I use for bar chart and KPI.

The measurement is SUM(.....). But this sum could be brake down by dimension machine. This I use in bar chart, where I use machine as dimension and same measurement.

My question is, if I want to have another KPI, that portray the Min() value of this measurement by machine. (So the machine with lowest measurement)

If I only do min(measurement,..) it will return the same value as previous KPI, because for him it is only one value, so min of one value is the same value.

Any suggestions?

Marko Zadravec

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Min( AGGR (  YourExpression  , DimensionToAggregateBy ) )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Min( AGGR (  YourExpression  , DimensionToAggregateBy ) )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
marjan_it
Creator III
Creator III

If dimension was a cycle group and we want to have aggr for each part of group how wee could get this?

Community Browser