Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

get min out of calc

hi com,

i want to get the min price per unit out of this calc

aggr(min(sum(total_price)/sum(amount)),article)

i that right or do i have a mistake in there, cause in my KPI there is no value shown!!

thanks,eric

1 Solution

Accepted Solutions
mgranillo
Specialist
Specialist

eric,

Aggr returns a table and a KPI needs a single value.  you need to wrap the aggr in another aggregation function.

Move the min outside the aggr function.

Mike

View solution in original post

2 Replies
mgranillo
Specialist
Specialist

eric,

Aggr returns a table and a KPI needs a single value.  you need to wrap the aggr in another aggregation function.

Move the min outside the aggr function.

Mike

sunny_talwar

Do you have a sample you can share with the output you would expect to see?