Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Kohli
Contributor

Script for total salary

I have Table Employee...

E.ID, Emp Name,  Month, Year, Salary

101, Hari, Jan, 2016, 15000

102, Kiran, Jan, 2016, 17000

101, Hari, Mar, 2016, 14000

107, Prem, Apr, 2016, 12000

108, Ashok, July, 2016, 18000

101, Hari, Feb, 2017, 15000

I want find the toata salary of Hari.

3 Replies

Re: Script for total salary

Try this,

Sum({<[Emp Name] = {"Hari"}>}Salary)

Regards,

Kaushik Solanki

Kohli
Contributor

Re: Script for total salary

Is it possible Sum(<{[ E.ID]={"101"]>}Salary);

Re: Script for total salary

Yes why not.

But correct your expression as below.

Sum({<[ E.ID]={"101"}>}Salary);


Regards,

Kaushik Solanki