employes

[Dmasvinc]

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 !

[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

[Dmasvinc]

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]

so can you help?

[Taoufiq_Zarra · Accepted solution]

attached my proposal

[Dmasvinc]

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