Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
richard24best
Creator
Creator

Show minimum and maximum dimension value in KPI

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

Labels (1)
1 Solution

Accepted Solutions
anat
Specialist II
Specialist II

3 Replies
anat
Specialist II
Specialist II

try using "Firstsortedvalue" function .

FirstSortedValue - chart function ‒ Qlik Sense on Windows

 

richard24best
Creator
Creator
Author

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
Specialist II
Specialist II

for min value

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