Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
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

salary_contribution.png

Here I'm posting a sample data with 3 employees

Hope some one can help me out of this

tresesco

stalwar1

tamilarasu

1 Solution

Accepted Solutions
yashdeep
Contributor III
Contributor III

Is this what you are looking for

View solution in original post

7 Replies
kakani87
Specialist
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

avkeep01
Partner - Specialist
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:

LOAD

EmployeeNr,

TimeSpend

FROM Table1;

LEFT JOIN (Table1) LOAD

EmployeeNr,

Salary

FROM Table2;

Table3:

NOCONCATENATE LOAD

EmployeeNr,

TimeSpend,

Salary/TimeSpend AS Salary_per_TimeSpen

RESIDENT Table1;

DROP TABLE Table1;

kakani87
Specialist
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

kakani87
Specialist
Specialist
Author

Hello  kindly someone can look into my issue

kakani87
Specialist
Specialist
Author

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

But the contribution calculation not yet

yashdeep
Contributor III
Contributor III

Is this what you are looking for

kakani87
Specialist
Specialist
Author

Thanks a lot Yashdeep for your support

This is what I'm looking  for