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: 
Dmasvinc
Contributor III
Contributor III

employes

Hi I m new to QlikView and I need to do some tasks, I will add data tables in pictures.

1). Identify the longest-serving employee in the company and indicate their seniority

2).Identify the best performing  sales plan manager for the selected period

3). identify the year and the month when the sales plan was best executed

4).Show the top sales manager

Thanks in advance !

1 Solution

Accepted Solutions
Taoufiq_Zarra

attached my proposal

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

5 Replies
Taoufiq_Zarra

Hi,

can you share your data in a usable format (xls,qvd,...)
formulate your needs :
1). Identify the longest-serving employee in the company and indicate their seniority

2/

...

for example how (you know your case best) to measure this performance
and so on

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Dmasvinc
Contributor III
Contributor III
Author

Hi, I just need expressions to calculate the following things:

1). Identify the longest-serving employee in the company and indicate their seniority.

2).Identify the best performing  manager in sales plan for the selected period for example  I select 2017 and then result shows the best manager by sales plan

3). identify the year and the month when the sales plan was best executed

4).Show the top sales manager by all period

and there is my data in xlsx

Dmasvinc
Contributor III
Contributor III
Author

so can you help?

Taoufiq_Zarra

attached my proposal

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Dmasvinc
Contributor III
Contributor III
Author

Thanks, you helped a lot!! its was very helpful!