set analysis

[Anonymous]

Hi  i  have  two tables  like

table1:                                                                   

EID ENAME    

1     mahesh

2 rajesh

3 uday

4 pavan

5 raghu

6 rafi

Table2:

EID  DEPT  SAL

1   HR    10000

2 SE   25000

3 HR   60000

4 SE  30000

5 HR 12900

6 SE 23000

I want to display the  top max  two salaries from each department

how to write this in set Analysis

[sunny_talwar]

Like this?

[Anonymous]

Hi  sunny

Thanks for  answer

But i was unable to open QVW file as  I am  desktop version ..

[Anonymous]

but  i want to display  in pivot table

as dept name

     HR  uday

            Raghu

     SE Pavan

           Rajesh

like this i dont want to use  two expression i want to right it in a single expression

[sunny_talwar · Accepted solution]

May be this:

If(Max(TOTAL <DEPT> SAL, 2) <= SAL, ENAME)

[Anonymous]

Thanks  Sunny  its working