Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (4)
1 Solution

Accepted Solutions
kidbank3
Contributor III

Re: get min out of calc

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

2 Replies
kidbank3
Contributor III

Re: get min out of calc

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

MVP
MVP

Re: get min out of calc

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