Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor III
Contributor III

Is this what you are looking for

View solution in original post

7 Replies
Highlighted
Specialist
Specialist

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

Highlighted
Partner
Partner

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;

Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

Hello  kindly someone can look into my issue

Highlighted
Specialist
Specialist

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

But the contribution calculation not yet

Highlighted
Contributor III
Contributor III

Is this what you are looking for

View solution in original post

Highlighted
Specialist
Specialist

Thanks a lot Yashdeep for your support

This is what I'm looking  for