topic Re: Pointage in QlikView

Pointage

Wed, 02 Jul 2014 10:52:34 GMT

AutoNum	iEventNum	bDoorNumber	dEvent_Date	iUserNum
331635	7147	2	16/06/2014 08:15	150
331650	7159	2	16/06/2014 08:19	150
331661	7169	2	16/06/2014 08:21	150
334343	8166	2	16/06/2014 18:50	150

Commet sortir a partir du champ " dEvent_Date" comme date d'entré 08:15 et date de sortie 18:50

Re: Pointage

maxgro — Wed, 02 Jul 2014 11:15:14 GMT

in a text box?

=time(min(frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))))

=time(max(frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))))

Re: Pointage

Wed, 02 Jul 2014 12:29:16 GMT

Dans le script .

Re: Pointage

hic — Wed, 02 Jul 2014 12:47:45 GMT

The conversion to time is straightforward:

Time(Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))) as Time

But how do you know whether a timestamp is Entré or Sortie? If you say that anything before 12:00 is an Entré and anything after is a Sortie, then you can do the following:

If( Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))<=0.5,

Time(Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))) as Temp_dEntre,

If( Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))>0.5,

Time(Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))) as Temp_de_Sortie,

But I am not sure that that is a good criterion...

HIC

Re: Pointage

Thu, 03 Jul 2014 08:51:46 GMT

la fonction min ne marche pas.

Re: Pointage

hic — Thu, 03 Jul 2014 09:16:53 GMT

Si tu utilises Min() dans le script, tu doit aussi utiliser un Groupe By, par example:

Load

iUserNum,

Min (dEvent_Date)

From ...

Group By iUserNum;

HIC