https://community.qlik.com/t5/App-Development/Heures-travaill%C3%A9es-par-les-%C3%A9quipes/m-p/1958409#M79007 <P>Merci beaucoup pour l'aide, c'est parfait&nbsp;<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span>.<BR /><BR />Bonne journée,<BR /><BR />Etienne</P> Wed, 20 Jul 2022 14:23:31 GMT GOHIERO35 2022-07-20T14:23:31Z https://community.qlik.com/t5/App-Development/Heures-travaill%C3%A9es-par-les-%C3%A9quipes/m-p/1952190#M78502 <P>Bonjour à tous,<BR /><BR /></P> <P>J'essaie d'analyser&nbsp; le temps travaillé des différents collaborateurs. Pour vous expliquer rapidement j'ai une table main_courante dans laquelle je dispose de toutes les actions réalisées par les équipes, dont les heures de connexions&nbsp; (main_type = 200)&nbsp; et de déconnexions (main_type=201).</P> <TABLE width="618px"> <TBODY> <TR> <TD width="203.438px" height="25px">DATE_DEBUT</TD> <TD width="110.891px" height="25px">MAIN_USER</TD> <TD width="107.891px" height="25px">MAIN_TYPE</TD> <TD width="194.781px" height="25px">MAIN_TYPE_LIBELLE</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 07:47:37</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">200</TD> <TD width="194.781px" height="25px">Connexion utilisateur</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 08:18:55</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">1</TD> <TD width="194.781px" height="25px">Consigne lue</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 08:39:46</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">1</TD> <TD width="194.781px" height="25px">Consigne lue</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 08:40:25</TD> <TD width="110.891px" height="25px">13216513</TD> <TD width="107.891px" height="25px">200</TD> <TD width="194.781px" height="25px">Connexion utilisateur</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 08:47:50</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">123</TD> <TD width="194.781px" height="25px">Création post it</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 08:48:00</TD> <TD width="110.891px" height="25px">13216513</TD> <TD width="107.891px" height="25px">127</TD> <TD width="194.781px" height="25px">Audio ok</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 09:10:27</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">1</TD> <TD width="194.781px" height="25px">Consigne lue</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 09:10:33</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">1</TD> <TD width="194.781px" height="25px">Consigne lue</TD> </TR> <TR> <TD width="203.438px" height="25px"><STRONG>01/07/2022 09:13:25</STRONG></TD> <TD width="110.891px" height="25px"><STRONG>29151691</STRONG></TD> <TD width="107.891px" height="25px"><STRONG>201</STRONG></TD> <TD width="194.781px" height="25px"><STRONG>Déconnexion utilisateur</STRONG></TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 09:24:06</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">123</TD> <TD width="194.781px" height="25px">Création post it</TD> </TR> <TR> <TD width="203.438px" height="25px"><STRONG>01/07/2022 09:24:39</STRONG></TD> <TD width="110.891px" height="25px"><STRONG>13216513</STRONG></TD> <TD width="107.891px" height="25px"><STRONG>201</STRONG></TD> <TD width="194.781px" height="25px"><STRONG>Déconnexion utilisateur</STRONG></TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 09:25:02</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">1</TD> <TD width="194.781px" height="25px">Consigne lue</TD> </TR> <TR> <TD width="203.438px" height="25px">01/07/2022 09:41:43</TD> <TD width="110.891px" height="25px">29151691</TD> <TD width="107.891px" height="25px">123</TD> <TD width="194.781px" height="25px">Création post it</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>J'aimerais pouvoir additionner toutes les durées de connexion de chaque main_user. Par exemple dans l'exemple ci-dessus ce serait d'ajouter une DUREE_CONNECTION sur chaque ligne "Déconnexion utilisateur".</P> <P>Cela donnerait par exemple pour l'exemple ci-dessus le résultat suivant:</P> <TABLE width="620"> <TBODY> <TR> <TD width="142.938px" height="25px">MAIN_DATE_DEBUT</TD> <TD width="90.1094px" height="25px">MAIN_USER</TD> <TD width="87.3281px" height="25px">MAIN_TYPE</TD> <TD width="149.109px" height="25px">MAIN_TYPE_LIBELLE</TD> <TD width="156.125px" height="25px">DUREE_CONNECTION</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 07:47:37</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">200</TD> <TD width="149.109px" height="47px">Connexion utilisateur</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 08:18:55</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">1</TD> <TD width="149.109px" height="47px">Consigne lue</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 08:39:46</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">1</TD> <TD width="149.109px" height="47px">Consigne lue</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 08:40:25</TD> <TD width="90.1094px" height="47px">13216513</TD> <TD width="87.3281px" height="47px">200</TD> <TD width="149.109px" height="47px">Connexion utilisateur</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 08:47:50</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">123</TD> <TD width="149.109px" height="47px">Création post it</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 08:48:00</TD> <TD width="90.1094px" height="47px">13216513</TD> <TD width="87.3281px" height="47px">127</TD> <TD width="149.109px" height="47px">Audio ok</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 09:10:27</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">1</TD> <TD width="149.109px" height="47px">Consigne lue</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 09:10:33</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">1</TD> <TD width="149.109px" height="47px">Consigne lue</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px"><STRONG>01/07/2022 09:13:25</STRONG></TD> <TD width="90.1094px" height="47px"><STRONG>29151691</STRONG></TD> <TD width="87.3281px" height="47px"><STRONG>201</STRONG></TD> <TD width="149.109px" height="47px"><STRONG>Déconnexion utilisateur</STRONG></TD> <TD width="156.125px" height="47px"><STRONG>1:25:48</STRONG></TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 09:24:06</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">123</TD> <TD width="149.109px" height="47px">Création post it</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="49px"><STRONG>01/07/2022 09:24:39</STRONG></TD> <TD width="90.1094px" height="49px"><STRONG>13216513</STRONG></TD> <TD width="87.3281px" height="49px"><STRONG>201</STRONG></TD> <TD width="149.109px" height="49px"><STRONG>Déconnexion utilisateur</STRONG></TD> <TD width="156.125px" height="49px"><STRONG>0:44:14</STRONG></TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 09:25:02</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">1</TD> <TD width="149.109px" height="47px">Consigne lue</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> <TR> <TD width="142.938px" height="47px">01/07/2022 09:41:43</TD> <TD width="90.1094px" height="47px">29151691</TD> <TD width="87.3281px" height="47px">123</TD> <TD width="149.109px" height="47px">Création post it</TD> <TD width="156.125px" height="47px">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P><STRONG>01/07/2022 09:13:25 - 01/07/2022 07:47:32 = 01:25:48</STRONG></P> <P><STRONG>01/07/2022 09:24:39 -&nbsp;01/07/2022 08:40:25 = 00:44:14</STRONG></P> <P>Et je voudrais pouvoir additionner tous ces intervalles pour chaque&nbsp; main_user.<BR /><BR />J'ai essayer avec peek() suite aux conseils d'un membre de la communauté mais je ne parviens pas au résultat escompté.<BR /><BR />Merci d'avance pour votre aide,<BR /><BR />Merci à tous,<BR /><BR />Etienne</P> Wed, 06 Jul 2022 08:15:04 GMT https://community.qlik.com/t5/App-Development/Heures-travaill%C3%A9es-par-les-%C3%A9quipes/m-p/1952190#M78502 GOHIERO35 2022-07-06T08:15:04Z https://community.qlik.com/t5/App-Development/Heures-travaill%C3%A9es-par-les-%C3%A9quipes/m-p/1952486#M78535 <P>Bonjour</P> <P>Je te conseille de charger une table temporaire filtrée uniquement sur les Maintype 200 et 201&nbsp;</P> <P>Et avec cette table calcule les temps de log ( reprend ton post où tu as eu ta réponse avec peek.)</P> <P>Puis tu charge ta table finale complète et tu fais un leftjoin avec les temps de log&nbsp; de ta table temporaire grâce à une clé de jointure&nbsp;</P> <P>Enfin tu drop ta table temporaire</P> <P>Cdt</P> <P>Bruno</P> Wed, 06 Jul 2022 17:20:37 GMT https://community.qlik.com/t5/App-Development/Heures-travaill%C3%A9es-par-les-%C3%A9quipes/m-p/1952486#M78535 brunobertels 2022-07-06T17:20:37Z https://community.qlik.com/t5/App-Development/Heures-travaill%C3%A9es-par-les-%C3%A9quipes/m-p/1958409#M79007 <P>Merci beaucoup pour l'aide, c'est parfait&nbsp;<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span>.<BR /><BR />Bonne journée,<BR /><BR />Etienne</P> Wed, 20 Jul 2022 14:23:31 GMT https://community.qlik.com/t5/App-Development/Heures-travaill%C3%A9es-par-les-%C3%A9quipes/m-p/1958409#M79007 GOHIERO35 2022-07-20T14:23:31Z