Show minimum and maximum dimension value in KPI

[richard24best]

Hi team,

I have a requirement to show Minimum and maximum value in KPI.

For example :

Dimension is Client Type (A,B, C, D, E)

Measure - sum(Volumes)

Client Type            sum(Volumes)

A                                         20

B                                        60

C                                        10

D                                        80

E                                       120

So the KPI should show Client Type Max - E(120) and Min - C (10). Is it possible?

Appreciate your time and support in advance.

Regards,

Richard

[anat · Accepted solution]

try using "Firstsortedvalue" function .

FirstSortedValue - chart function ‒ Qlik Sense on Windows

[richard24best]

Hi Anat,

Thanks for your response.

I did use the below expression to derive Max but not sure what is it to derive minimum value

FirstSortedValue(ClientType, -Aggr(Sum(Volumes), ClientType))

Regards,

Richard

[anat]

for min value

FirstSortedValue(ClientType, Aggr(Sum(Volumes), ClientType))

[GOKULAKANNAN]

But its not working, I'm having more than 1 values which is having minimum values, in this case, how can we acheieve.