Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Hareeshkommineni
Contributor III
Contributor III

i want to display 1st two highest salarys

my table:

emp_IDemp_Nameemp_Sal
1AA200
2BB400
3CC500
4DD600
5EE700
6FF200

 

 

Experted OUTPUT:

EMP_IDEMP_NameEmp_Sal
4DD600
5EE700
5 Replies
Sue_Macaluso
Community Manager
Community Manager

Hi, I would like to get this into the correct product forum as this is for general discussions. Are you referring to QlikView or Sense? Thanks
Sue Macaluso
Hareeshkommineni
Contributor III
Contributor III
Author

Qlikview
sunny_talwar

Is this needed to be done in the script or a front end chart?

gayathridevi24
Contributor III
Contributor III

Hi Hareesh,

Are you expecting the answer like as attached.

Please find the attached document.

 

 

Thanks and Regards,

Gayathri

VishalWaghole
Specialist II
Specialist II

Try below expression,

If(Rank(sum(Emp_Sal)) >= 2, sum(Emp_Sal))

Hope this will work for you.

Regards,
Vishal Waghole