Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

New Contributor II

Need Help in Logic

I have a requirement in which I need to add values for duplicate employee Id's

and then map that added value and emp id  in another excel sheet

eg-In my sheet I have 2 columns Emp id and Days I need to add days by grouping the empid

Employee id 101 is present in my sheet 3 times and each having some value for days

empid    days

101         7

102         8

103         6

101         5

101         8

103         10

so it should give

Empid     total_days

101          20

102          8

103         16

After grouping the emp id's I need to map these id in another excel sheet which has unique empid.

Community Browser