i want to display 1st two highest salarys

[Hareeshkommineni]

my table:

emp_ID	emp_Name	emp_Sal
1	AA	200
2	BB	400
3	CC	500
4	DD	600
5	EE	700
6	FF	200

Experted OUTPUT:

EMP_ID	EMP_Name	Emp_Sal
4	DD	600
5	EE	700

[Sue_Macaluso]

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

[Hareeshkommineni]

Qlikview

[sunny_talwar]

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

[gayathridevi24]

Hi Hareesh,

Are you expecting the answer like as attached.

Please find the attached document.

Thanks and Regards,

Gayathri

[VishalWaghole]

Try below expression,

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

Hope this will work for you.

Regards,
Vishal Waghole