topic Re: Conversion seconde en minute in QlikView https://community.qlik.com/t5/QlikView/Conversion-seconde-en-minute/m-p/1355544#M823117 <HTML><HEAD></HEAD><BODY><P>Bonjour Chadlia,</P><P>peut etre</P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Time</SPAN>(<SPAN style="color: #0000ff;">Time#</SPAN></SPAN><SPAN style="font-size: 10pt;">(869,'ss'),'mm:ss') </SPAN></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172527_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Au Revoir,</P><P>Antonio</P></BODY></HTML> Fri, 04 Aug 2017 14:54:38 GMT antoniotiman 2017-08-04T14:54:38Z Conversion seconde en minute https://community.qlik.com/t5/QlikView/Conversion-seconde-en-minute/m-p/1355543#M823116 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P>j'ai deux variables temporelles calculées en seconde et je veux les afficher en format mm:ss j'ai essayé nombre Heure et le format hh:mm:ss il me donne pas les bons résultats.</P><P>Comment pourrai je convertir seconde en minute.</P><P>Merci.</P><P><IMG alt="test.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172516_test.png" style="height: 318px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Conversion-seconde-en-minute/m-p/1355543#M823116 chadliagabsi 2020-11-25T16:16:04Z Re: Conversion seconde en minute https://community.qlik.com/t5/QlikView/Conversion-seconde-en-minute/m-p/1355544#M823117 <HTML><HEAD></HEAD><BODY><P>Bonjour Chadlia,</P><P>peut etre</P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Time</SPAN>(<SPAN style="color: #0000ff;">Time#</SPAN></SPAN><SPAN style="font-size: 10pt;">(869,'ss'),'mm:ss') </SPAN></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172527_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Au Revoir,</P><P>Antonio</P></BODY></HTML> Fri, 04 Aug 2017 14:54:38 GMT https://community.qlik.com/t5/QlikView/Conversion-seconde-en-minute/m-p/1355544#M823117 antoniotiman 2017-08-04T14:54:38Z Re: Conversion seconde en minute https://community.qlik.com/t5/QlikView/Conversion-seconde-en-minute/m-p/1355545#M823118 <HTML><HEAD></HEAD><BODY><P>Salut,</P><P></P><P>une autre solution pourrait être:</P><P><IMG alt="QlikCommunity_Thread_270191_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172560_QlikCommunity_Thread_270191_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15018840865851366 jive_text_macro" jivemacro_uid="_15018840865851366"> <P>LOAD *,</P> <P>&nbsp;&nbsp;&nbsp; Interval([TEMPS D'ATTENTE MAXIMUM SECOND]/86400,'hh:mm:ss') as [TEMPS D'ATTENTE MAXIMUM];</P> <P>LOAD Ceil(Rand()*100000) as [TEMPS D'ATTENTE MAXIMUM SECOND]</P> <P>AutoGenerate 20;</P> </PRE><P></P><P>Faites attention d'utiliser la fonction <A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/FormattingFunctions/Interval.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/FormattingFunctions/Interval.htm">Interval()</A> s'il y a des temps plus d'un jour.</P><P></P><P>cordialement</P><P>Marco</P></BODY></HTML> Fri, 04 Aug 2017 22:16:26 GMT https://community.qlik.com/t5/QlikView/Conversion-seconde-en-minute/m-p/1355545#M823118 MarcoWedel 2017-08-04T22:16:26Z