topic Re: KPI in Visualization and Usability

KPI

Umer1 — Thu, 09 May 2024 06:44:05 GMT

“min(aggr(minvalue,[shed.id], medvacname”

Above expression is use to get the minimum loss by the medicine
in this expression ‘minvalue’ is a master measure which is

if(Min(aggr(Sum(Cumm_CulledMedicine)+sum(Cumm_MortalityMedicine),[shed.id],medvacname))>0,min(aggr(Sum(Cumm_CulledMedicine)+sum(Cumm_MortalityMedicine),[shed.id],medvacname)))

What I actually wants a name associated with the above expression(“min(aggr(minvalue,[shed.id], medvacname))”) but it is not working and I did not understand the problem. How can I get the medvacname where the minvalue in minimum but it should be greater than zero

Re: KPI

MatheusC — Thu, 09 May 2024 13:03:32 GMT

Maybe using the FirstSortedValue function

https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.htm

FirstSortedValue(medvacname,aggr(minvalue,medvacname))

Regarts, Matheus

Re: KPI

Umer1 — Tue, 21 May 2024 07:45:14 GMT

Thankyou, Matheus