topic Re: Convertir minutes en heures in QlikView https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453466#M169179 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">&nbsp; Ce script ne marche pas : <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></SPAN></P><P><SPAN style="font-size: 12pt;"></SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 12pt;"></SPAN></P><P>TEST:</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;"><STRONG style="color: #0000ff;"><STRONG>LOAD</STRONG></STRONG></SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">Hour</SPAN>(<SPAN style="color: #800000;">MYCOLUMN</SPAN>)&amp;'h'&amp;<SPAN style="color: #0000ff;">Minute</SPAN>(<SPAN style="color: #800000;">MYCOLUMN</SPAN>) <SPAN style="color: #0000ff;">as</SPAN>&nbsp; <SPAN style="color: #800000;">NEWCOLUMN</SPAN></SPAN></P><P></P><P></P></BODY></HTML> Wed, 20 Feb 2013 09:20:22 GMT 2013-02-20T09:20:22Z Convertir minutes en heures https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453465#M169178 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>J'ai une colonne de type 'Nombre" qui represente le nombre de minutes</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Minutes</STRONG></SPAN></TH></TR><TR><TD>2</TD></TR><TR><TD>68</TD></TR><TR><TD>15</TD></TR><TR><TD>72</TD></TR></TBODY></TABLE><P>Je souhaiterai la representer une format heures</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="114" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 252px; HEIGHT: 85px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Minutes</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Heures</STRONG></SPAN></TH></TR><TR><TD>2</TD><TD>0H02</TD></TR><TR><TD>68</TD><TD>1H08</TD></TR><TR><TD>15</TD><TD>0H15</TD></TR><TR><TD>72</TD><TD>1H12</TD></TR></TBODY></TABLE><P></P><P>Je n'arrime pas avoir un solution</P><P></P><P>Merci pour votre aide.</P></BODY></HTML> Wed, 20 Feb 2013 09:14:52 GMT https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453465#M169178 2013-02-20T09:14:52Z Re: Convertir minutes en heures https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453466#M169179 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">&nbsp; Ce script ne marche pas : <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></SPAN></P><P><SPAN style="font-size: 12pt;"></SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 12pt;"></SPAN></P><P>TEST:</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;"><STRONG style="color: #0000ff;"><STRONG>LOAD</STRONG></STRONG></SPAN></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">Hour</SPAN>(<SPAN style="color: #800000;">MYCOLUMN</SPAN>)&amp;'h'&amp;<SPAN style="color: #0000ff;">Minute</SPAN>(<SPAN style="color: #800000;">MYCOLUMN</SPAN>) <SPAN style="color: #0000ff;">as</SPAN>&nbsp; <SPAN style="color: #800000;">NEWCOLUMN</SPAN></SPAN></P><P></P><P></P></BODY></HTML> Wed, 20 Feb 2013 09:20:22 GMT https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453466#M169179 2013-02-20T09:20:22Z Re: Convertir minutes en heures https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453467#M169180 <HTML><HEAD></HEAD><BODY><P>Salut,</P><P></P><P>Voici une solution possible:</P><P></P><P></P><P>minutes:</P><P><STRONG style=": ; color: #0000ff; font-size: 10pt;">LOAD</STRONG><SPAN style="font-size: 10pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Inline</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800000; font-size: 10pt;">[<BR />minutes<BR />2<BR />68<BR />15<BR />72<BR />940<BR />]</SPAN><SPAN style="font-size: 10pt;">;<BR /><BR /><EM>hours</EM>:<BR /></SPAN><STRONG style=": ; color: #0000ff; font-size: 10pt;">LOAD</STRONG><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800080; font-size: 10pt;">num</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800080; font-size: 10pt;">Floor</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">minutes</SPAN><SPAN style="font-size: 10pt;">/60), </SPAN><SPAN style="color: #ff8000; font-size: 10pt;">'0'</SPAN><SPAN style="font-size: 10pt;">) &amp; </SPAN><SPAN style="color: #ff8000; font-size: 10pt;">'H'</SPAN><SPAN style="font-size: 10pt;"> &amp; </SPAN><SPAN style="color: #800080; font-size: 10pt;">num</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">minutes</SPAN><SPAN style="font-size: 10pt;"> - (</SPAN><SPAN style="color: #800080; font-size: 10pt;">Floor</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">minutes</SPAN><SPAN style="font-size: 10pt;">/60) * 60), </SPAN><SPAN style="color: #ff8000; font-size: 10pt;">'00'</SPAN><SPAN style="font-size: 10pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">as</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800000; font-size: 10pt;">hours</SPAN><SPAN style="font-size: 10pt;"><BR /></SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Resident</SPAN><SPAN style="font-size: 10pt;"> <EM>minutes</EM>; </SPAN></P><P></P><P></P></BODY></HTML> Wed, 20 Feb 2013 09:28:00 GMT https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453467#M169180 2013-02-20T09:28:00Z Re: Convertir minutes en heures https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453468#M169181 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 12pt;">J'ai trouvé la solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">interval( <SPAN style="color: #800000;">MYCOLUMN</SPAN>/24/60, 'hh:mm') <SPAN style="color: #0000ff;">as</SPAN>&nbsp; <SPAN style="color: #800000;">NEWCOLUMN</SPAN> </SPAN></P></BODY></HTML> Wed, 20 Feb 2013 09:28:04 GMT https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453468#M169181 2013-02-20T09:28:04Z Re: Convertir minutes en heures https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453469#M169182 <HTML><HEAD></HEAD><BODY><P>C'est un type de données <STRONG>Interval</STRONG>. Vous devez utiliser l'expression suivante:</P><P></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Interval(Minutes / (24 * 60)) AS Houres</STRONG></P><P></P><P>Juan Gerardo</P></BODY></HTML> Wed, 20 Feb 2013 09:28:24 GMT https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453469#M169182 2013-02-20T09:28:24Z Re: Convertir minutes en heures https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453470#M169183 <HTML><HEAD></HEAD><BODY><P>Merci pour votre reponse, mais ma colonne avec de minutes sorts de la Base de données et je ne sais pas d'avance quels données charger ....</P></BODY></HTML> Wed, 20 Feb 2013 09:30:26 GMT https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453470#M169183 2013-02-20T09:30:26Z Re: Convertir minutes en heures https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453471#M169184 <HTML><HEAD></HEAD><BODY><P>Merci ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 20 Feb 2013 09:31:07 GMT https://community.qlik.com/t5/QlikView/Convertir-minutes-en-heures/m-p/453471#M169184 2013-02-20T09:31:07Z