topic Re: Staff turnover with Set Analysis in QlikView

Staff turnover with Set Analysis

Mon, 19 Sep 2011 10:43:37 GMT

Hi everybody,

I’m working on a datebase with a field called « Month » (format ‘MMM-YY’).

Each month, I add the company personnel list relative to said month.

What I’d like to do is, by selecting one month, display the staff “in” and the staff “out” compared to the previous month.
I’m wondering if I have to declare some variables in the script to use Set Analysis functions.

Thanks in advance for your help

Re: Staff turnover with Set Analysis

Mon, 19 Sep 2011 10:53:55 GMT

Hi Flalanne,

i attach a file posted for an old similar question.

In this example the field "pres" is set to 1 if the relativ cust is present in that month/year, 0 if not.

For example if in march pres is 0 and in april 1, the relative custmer is entered.

I hope it's useful.

Stefano

Re: Staff turnover with Set Analysis

Mon, 19 Sep 2011 13:20:35 GMT

Hi Flalanne,

this file is better... I use P() and E() function in set analysis.

In this way it's not necessary to have all record in the originary table.

C u,

Stefano.

Re: Staff turnover with Set Analysis

Mon, 19 Sep 2011 14:01:07 GMT

Perfect ! Exactly what I need. Thanks

Re: Staff turnover with Set Analysis

Wed, 21 Sep 2011 07:56:07 GMT

Actually, it works perfectly for the staff entrances, but there is no result for the departures.

In your exemple, the value of pres2 field is 0 whereas the line is deleted in my application.

Any idea ?

Thanks.

Franck

Re: Staff turnover with Set Analysis

Wed, 21 Sep 2011 08:29:29 GMT

Hi Franck,

try if this is ok.

C u,

Stefano

Re: Staff turnover with Set Analysis

Wed, 21 Sep 2011 08:44:09 GMT

Thank you so much Stefano ! It works !