topic Re: employes in QlikView

employes

Dmasvinc — Wed, 25 Nov 2020 16:16:04 GMT

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 !

Re: employes

Taoufiq_Zarra — Tue, 17 Dec 2019 13:58:32 GMT

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

...

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

Re: employes

Dmasvinc — Tue, 17 Dec 2019 14:08:45 GMT

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

Re: employes

Dmasvinc — Tue, 17 Dec 2019 19:08:18 GMT

so can you help?

Re: employes

Taoufiq_Zarra — Tue, 17 Dec 2019 19:54:33 GMT

attached my proposal

Re: employes

Dmasvinc — Wed, 18 Dec 2019 18:40:08 GMT

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