Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
SRI8273
Contributor II
Contributor II

how to find the max and min values randomly from the data

load * Inline [
ID,Date,Customer,SalesA
1,1@1@2022,sri1,100
2,2@1-2022,sri2,200
3,3@1@2022,sri3,600
4,4@1@2022,sri4,1800
5,5@1@2022,sri5,10000
6,6@1@2022,sri6,25000
7,7@1@2022,sri7,1500
8,8@1@2022,sri8,2000
9,9@1@2022,sri9,4500
10,10@1@2022,sri10,8000
]
;

i want  to know the 2nd or 3rd max values and min values 

Labels (1)
2 Replies
N30fyte
Creator
Creator

minmax.jpg

 

 

 

 

 

 

 

(Slightly different field name.)