Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Did you mean:
Specialist

## help Salary contribution calculation in costing dashboard

Hi Folks ....

My requirement is to display the salary contribution product/item_family wise of a employee in a month based on the spent time for that product in a day

finally that contribution need to be summarized and divide the salary product wise

below is the screen with required contribution to display

lets say an employee salaried 20000 monthly and based on the product wise contribution daily and that is to be shown month

Same details in an excel  attachment

but here for one employee I'm displaying to understand

Here I'm posting a sample data with 3 employees

Hope some one can help me out of this

1 Solution

Accepted Solutions
Contributor III

Is this what you are looking for

7 Replies
Specialist
Author
MonthEmpItem/ProductSpenttimecontributionsalary
Apr-18Emp1P180 hrs408000
Apr-18Emp1P2120 hrs6012000

Required output

For example-

If an employee contributed for two products P1 and P2 as 40:60 ratio and salary is 20000  for a month

P1 = 8000

P2 = 12000

like that to be displayed

Partner - Specialist

Hi Kakani,

so on the first table you have the time spend and an employee number basically. On the second table you have the salary and the employee number.

What you could do, and i'll create a basic example, is joining the tables as a first step:

Table1:

EmployeeNr,

TimeSpend

FROM Table1;

LEFT JOIN (Table1) LOAD

EmployeeNr,

Salary

FROM Table2;

Table3:

EmployeeNr,

TimeSpend,

Salary/TimeSpend AS Salary_per_TimeSpen

RESIDENT Table1;

DROP TABLE Table1;

Specialist
Author

Hi Van Keep,

Thanks alot for your response

here when i do left join salary is not displayed

In the table having time spent is on a product worked as well available

Specialist
Author

Hello  kindly someone can look into my issue

Specialist
Author

This issue of item display is due to date format and corrected

But the contribution calculation not yet

Contributor III

Is this what you are looking for

Specialist
Author

Thanks a lot Yashdeep for your support

This is what I'm looking  for

Community Browser