topic Adding Custom Field Based on the Available Field in QlikView

Adding Custom Field Based on the Available Field

Wed, 13 Jul 2011 06:48:59 GMT

I have 2 fields emp_name and salary...I need to add third Field called as Rank which should have data based on the salary of Employees..like

emp_name salary rank

Jim 60000 2

Peter 50000 3

Ram 70000 1

Can Anyone Help?

perumal_41 — Wed, 13 Jul 2011 07:22:02 GMT

use rank function in load statement rank( col1)

kaushiknsolanki — Wed, 13 Jul 2011 07:34:08 GMT

Hi,

Try this way.

load

RowNo() as Rank,

emp_name as E_N,

sum(salary) as Sal

resident Data Group by emp_name order by salary desc;

Regards,

Kaushik Solanki