Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Hareeshkommineni
New 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
Community Manager
Community Manager

Re: i want to display 1st two highest salarys

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
New Contributor III

Re: i want to display 1st two highest salarys

Qlikview

Re: i want to display 1st two highest salarys

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

gayathridevi24
New Contributor III

Re: i want to display 1st two highest salarys

Hi Hareesh,

Are you expecting the answer like as attached.

Please find the attached document.

 

 

Thanks and Regards,

Gayathri

Highlighted
VishalWaghole
Valued Contributor II

Re: i want to display 1st two highest salarys

Try below expression,

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

Hope this will work for you.

Regards,
Vishal Waghole