topic Re: Ayuda in QlikView https://community.qlik.com/t5/QlikView/Ayuda/m-p/397014#M147903 <HTML><HEAD></HEAD><BODY><P>mi amigo igual no me da, pongo en el script como me la mensionas... y en las expresiones hago la formula de count(distint(cotizacion).... en la pantalla de qlicview en el campo de la cantidad total me da <STRONG>874,225, </STRONG>pero cuando lo bajo a excel y hago la suma de la columna manual me da otro monto <STRONG>1,330,967</STRONG></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 442px;"><TBODY><TR><TD height="20" style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd; background-color: #4f81bd;" width="80">AÑO/MES</TD><TD style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd; background-color: #4f81bd;" width="80">ESTADO</TD><TD style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd; background-color: #4f81bd;" width="80">APC</TD><TD style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd; background-color: #4f81bd;" width="80">FAMILIA</TD><TD class="xl65" style="font-size: 8pt; color: black; font-weight: bold; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;" width="122">QT COTIZACIONES</TD></TR><TR><TD align="right" height="20" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;"><BR /></TD><TD align="right" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;"><BR /></TD><TD align="right" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;"><BR /></TD><TD align="right" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;"><EM><STRONG>suma de cotizaciones</STRONG></EM></TD><TD class="xl66" style="font-size: 8pt; color: black; font-weight: bold; font-family: Tahoma; border-width: 1pt 0.5pt; border-style: solid; border-color: silver; background-color: yellow;">874,225</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0100</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">49</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0200</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">41</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0204</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">4</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0300</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">15</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd;">0301</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">18</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 23 May 2013 23:27:01 GMT 2013-05-23T23:27:01Z Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397009#M147898 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt; font-family: 'Century Gothic','sans-serif';">Buenos días, necesito ayuda con una consulta de Qlikview, necesito sacar un indicador de cuantos pedidos de ventas hay en la base de datos, esto lo hago la formula </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Century Gothic','sans-serif'; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Century Gothic','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Century Gothic','sans-serif'; color: blue;">DISTINCT</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Century Gothic','sans-serif'; color: black;">( </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Century Gothic','sans-serif'; color: maroon;">COTIZACION</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Century Gothic','sans-serif'; color: black;">)), solo que necesito hacerlo por varias agrupaciones, cuantas hay por equipo de ventas y cuantas hay en cada equipo por familias de productos, el problema que me da es cuando agrego el campo de familias me un dato mas alto…</SPAN></P><P><STRONG style="color: black; font-size: 9.0pt; font-family: 'Century Gothic','sans-serif';">Por ejemplo:</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Century Gothic','sans-serif'; color: black;"> si en la base de datos agrego el campo de Equipo me da cálculo de <STRONG>109,439</STRONG> y cuando agrego el campo de familias me da un cálculo de <STRONG>166,564…</STRONG></SPAN></P></BODY></HTML> Wed, 22 May 2013 15:58:23 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397009#M147898 2013-05-22T15:58:23Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397010#M147899 <HTML><HEAD></HEAD><BODY><P>Hola Luis,</P><P></P><P>lo que sucede es que los valores del campo Cotizacion se repiten para diferentes combinaciones</P><P></P><P>miremos este caso</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>Familia</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Equipo</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Cotizacion</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1</TD><TD>2</TD><TD>1</TD></TR><TR><TD>1</TD><TD>3</TD><TD>2</TD></TR><TR><TD>1</TD><TD>4</TD><TD>3</TD></TR><TR><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>2</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P>entonces si cuentas cotizacion sin agrupar por ningun campo va a dar count(Distinct Cotizacion) = 3</P><P></P><P>si agrupar por equipo Load Equipo, count(Distinct Cotizacion) --&gt; 5</P><P></P><P>y si agrupas por todos los campos te va a dar 6.</P></BODY></HTML> Wed, 22 May 2013 17:20:01 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397010#M147899 Anonymous 2013-05-22T17:20:01Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397011#M147900 <HTML><HEAD></HEAD><BODY><P>y habra manera de poder hacer ese conteo?</P><P></P><P>lo que quiero es saber cuantas hay de cada equipo por familia...</P></BODY></HTML> Wed, 22 May 2013 17:32:41 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397011#M147900 2013-05-22T17:32:41Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397012#M147901 <HTML><HEAD></HEAD><BODY><P>Claro</P><P></P><P>Load Familia, Equipo, count(Distinct Cotizacion)</P><P>resident tablaDatos</P><P>group by Familia, Equipo;</P></BODY></HTML> Wed, 22 May 2013 17:34:47 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397012#M147901 Anonymous 2013-05-22T17:34:47Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397013#M147902 <HTML><HEAD></HEAD><BODY><P>lo pones en el script</P><P></P><P>Load Familia, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Equipo, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count(Distinct Cotizacion) as CantidadCotizacion</P><P>resident tufuentededatos</P><P>group by Familia, Equipo;</P></BODY></HTML> Wed, 22 May 2013 18:50:03 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397013#M147902 Anonymous 2013-05-22T18:50:03Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397014#M147903 <HTML><HEAD></HEAD><BODY><P>mi amigo igual no me da, pongo en el script como me la mensionas... y en las expresiones hago la formula de count(distint(cotizacion).... en la pantalla de qlicview en el campo de la cantidad total me da <STRONG>874,225, </STRONG>pero cuando lo bajo a excel y hago la suma de la columna manual me da otro monto <STRONG>1,330,967</STRONG></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 442px;"><TBODY><TR><TD height="20" style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd; background-color: #4f81bd;" width="80">AÑO/MES</TD><TD style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd; background-color: #4f81bd;" width="80">ESTADO</TD><TD style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd; background-color: #4f81bd;" width="80">APC</TD><TD style="font-size: 9pt; color: white; font-weight: bold; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd; background-color: #4f81bd;" width="80">FAMILIA</TD><TD class="xl65" style="font-size: 8pt; color: black; font-weight: bold; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;" width="122">QT COTIZACIONES</TD></TR><TR><TD align="right" height="20" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;"><BR /></TD><TD align="right" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;"><BR /></TD><TD align="right" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;"><BR /></TD><TD align="right" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;"><EM><STRONG>suma de cotizaciones</STRONG></EM></TD><TD class="xl66" style="font-size: 8pt; color: black; font-weight: bold; font-family: Tahoma; border-width: 1pt 0.5pt; border-style: solid; border-color: silver; background-color: yellow;">874,225</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0100</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">49</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0200</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">41</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0204</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">4</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none solid; border-top-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #4f81bd;">0300</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">15</TD></TR><TR><TD height="19" style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd; border-left-width: 0.5pt; border-left-color: #4f81bd;">Aug 12</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd;">GENERADA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd;">AAVILA</TD><TD style="font-size: 9pt; color: black; font-family: 'Century Gothic'; border-top-width: 0.5pt; border-style: solid none; border-top-color: #4f81bd; border-bottom-width: 0.5pt; border-bottom-color: #4f81bd;">0301</TD><TD class="xl67" style="font-size: 8pt; color: black; font-family: Tahoma; border: 0.5pt solid silver; background-color: yellow;">18</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 23 May 2013 23:27:01 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397014#M147903 2013-05-23T23:27:01Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397015#M147904 <HTML><HEAD></HEAD><BODY><P>Hola Luis,</P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">Load Familia,</P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Equipo,</P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count(Distinct Cotizacion) as CantidadCotizacion</P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">resident tufuentededatos</P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">group by Familia, Equipo;</P><P></P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">esto va en el editor del script</P><P></P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">y en la parte grafica debes es sumar el campo CantidadCotizacion</P><P></P><P style="background-color: #ffffff; font-size: 13px; color: #737373; font-family: Arial;">Sum(CantidadCotizacion)</P></BODY></HTML> Thu, 23 May 2013 23:37:12 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397015#M147904 Anonymous 2013-05-23T23:37:12Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397016#M147905 <HTML><HEAD></HEAD><BODY><P>lo que pasa es que el campo de cotizaciones es de texto por eso uso la formula de contar...</P></BODY></HTML> Fri, 24 May 2013 13:38:30 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397016#M147905 2013-05-24T13:38:30Z Re: Ayuda https://community.qlik.com/t5/QlikView/Ayuda/m-p/397017#M147906 <HTML><HEAD></HEAD><BODY><P>Luis pero es que yo no estoy diciendo que sumes el campo cotizacion estoy diciendo que sumes el campo CantidadCotizacion. El cual es un campo calculado durante la carga del script. </P></BODY></HTML> Fri, 24 May 2013 14:32:42 GMT https://community.qlik.com/t5/QlikView/Ayuda/m-p/397017#M147906 Anonymous 2013-05-24T14:32:42Z