Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aarav021
Contributor III
Contributor III

Calculating Salary Increase After 1 year, 2 year, 3 Year

Hi Folks,

I have an inline table below need to calculate increased salary For 1 Year, 2 Year and 3 year based on Salary hike given. 

EMPID, Current Salary, Hike 

'1', '20000', '20%'

'2', '30000',  '30%'

'3', '40000', '40%'

 

Can anyone help with salary increase for 1st year. 2nd year, 3rd Year for employee 1 in an KPI ?

This is an urgent requirement. 

2 Solutions

Accepted Solutions
MayilVahanan

Hi

Try like below
Dim: Emp ID, Current Salary, Hike

Exp:
1st Year =[Current Salary]*Hike

2nd Year =([Current Salary]+Column(1)) *Hike
3rd Year=([Current Salary]+Column(2)) *Hike

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

Kushal_Chawda

@aarav021  you can try below. Create 3 master measures for 3 Year expression and one Variable to store Hike. I have put EMPID=1 in set expression as mentioned,  to make it dynamic for other employees you can remove that set (EMPID=1) so that you can select any EMPID and see the results in KPI.

For Hike, I am assuming it is in Decimal format for eg. 0.2 or 20%. If it is in Number format like 20, then divide it by 100 to make it decimal format in variable

 

Varible: vHike
Expression : sum({<EMPID={1}>}[Hike])

1st Year
Master Measure Name : SalaryIncrease_1Year
Expression:
=rangesum(Sum({<EMPID={1}>}CurrentSalary),Sum({<EMPID={1}>}CurrentSalary) * $(vHike))

2nd Year
Master Measure Name : SalaryIncrease_2Year
Expression:
=rangesum([SalaryIncrease_1Year],SalaryIncrease_1Year] * $(vHike))

3rd Year
Master Measure Name : SalaryIncrease_3Year
Expression:
=rangesum([SalaryIncrease_2Year],SalaryIncrease_2Year] * $(vHike))

 

 

Now, Your Master measure stores actual salary and not the actual increased salary. To get that you can now use below expression in your charts or KPI

 

 

1st Year:
=[SalaryIncrease_1Year]-Sum({<EMPID={1}>}CurrentSalary)

2nd Year:
=[SalaryIncrease_2Year]-[SalaryIncrease_1Year]

3rd Year:
=[SalaryIncrease_3Year]-[SalaryIncrease_2Year]

 

 

View solution in original post

4 Replies
Kushal_Chawda

@aarav021  can you provide some sample data with expected output?

aarav021
Contributor III
Contributor III
Author

KPI for 1st year for first emp should show - 4000 (20% of 20000 is 4000, so salary increase for 1st year is 4,000, similary need to show for other years also, so just need an expression)

 

MayilVahanan

Hi

Try like below
Dim: Emp ID, Current Salary, Hike

Exp:
1st Year =[Current Salary]*Hike

2nd Year =([Current Salary]+Column(1)) *Hike
3rd Year=([Current Salary]+Column(2)) *Hike

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Kushal_Chawda

@aarav021  you can try below. Create 3 master measures for 3 Year expression and one Variable to store Hike. I have put EMPID=1 in set expression as mentioned,  to make it dynamic for other employees you can remove that set (EMPID=1) so that you can select any EMPID and see the results in KPI.

For Hike, I am assuming it is in Decimal format for eg. 0.2 or 20%. If it is in Number format like 20, then divide it by 100 to make it decimal format in variable

 

Varible: vHike
Expression : sum({<EMPID={1}>}[Hike])

1st Year
Master Measure Name : SalaryIncrease_1Year
Expression:
=rangesum(Sum({<EMPID={1}>}CurrentSalary),Sum({<EMPID={1}>}CurrentSalary) * $(vHike))

2nd Year
Master Measure Name : SalaryIncrease_2Year
Expression:
=rangesum([SalaryIncrease_1Year],SalaryIncrease_1Year] * $(vHike))

3rd Year
Master Measure Name : SalaryIncrease_3Year
Expression:
=rangesum([SalaryIncrease_2Year],SalaryIncrease_2Year] * $(vHike))

 

 

Now, Your Master measure stores actual salary and not the actual increased salary. To get that you can now use below expression in your charts or KPI

 

 

1st Year:
=[SalaryIncrease_1Year]-Sum({<EMPID={1}>}CurrentSalary)

2nd Year:
=[SalaryIncrease_2Year]-[SalaryIncrease_1Year]

3rd Year:
=[SalaryIncrease_3Year]-[SalaryIncrease_2Year]